Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have several rows of text with alternate rows coloured blue.
Column A has a date and columns B and C contain text data. 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 Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting, change row to certain color | Excel Worksheet Functions | |||
Conditional formatting - coloured text | Excel Worksheet Functions | |||
Conditional formatting does not change when values change. ?? | Excel Worksheet Functions | |||
How do I use Conditional Formatting to change pos No to a Neg No | Excel Discussion (Misc queries) | |||
Can't change font on conditional formatting | Excel Programming |