View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JH JH is offline
external usenet poster
 
Posts: 64
Default 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