I have several rows of text with alternate rows coloured blue.
Column A has a date and columns B and C contain
Is there a way to have those alternate rows change colour when the
date changes in Column A?
Below is the text in this new spreadsheet so far, to illustrate. I
have returned or will return library items as per the dates below.
But it would be nice to have the spreadsheet's conditional formatting
change when the date changes in Column A. I manually have the entire
spreadsheet set for blue&white but I realized when I printed out the
sheet today to take with me to the library, that it'll be easier to
have the rows change to one other colour combination so that I have
blocks of blue&white, then, say, yellow+white, blue&white,
yellow&white, etc., down the page. Is it possible to do something
like this programmatically?
Jul.14.2006 CD soundtrack Empire Strikes Back.
Jul.14.2006 CD audiobook Positive Attitude Training.
Jul.15.2006 CD audiobook 1 Minute Millionaire
Jul.15.2006 CD audiobook 7 Steps to Fearless Speaking
Jul.15.2006 CD audiobook Animals, Inc.
Jul.15.2006 CD audiobook The Success Principles