dates and conditional formatting
I have a spreadsheet (excel 2003) that has the month in column A2 and the
days in column b1, c1 etc. Please see the example below. I would like to use
conditional formatting to identify ,by fill color, weekends in the
appropriate cells, for example Jan 5th and 6th. I am very perplexed. Any help
would be much appreciated. Thanks.
a b c d e f g h i j etc
1 2 3 4 5 6 7 8 9
Jan
Feb
JH
|