dates and conditional formatting

[JH]

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

 

[John Moore]

It would be a lot easier to use Conditional formatting if you can do the
following...

A B C D E F G H I
Day 1 2 3 4 5 6 7 8
Jan M T W T F S S M
Feb S M T W T F S S

Note the Months now start in row A2, with row 1 being used to siginify the
days of the month ( 1 thru 31 ). You can then use conditional format on the
days ( M = Monday, T = Tuesday etc etc ) and format the Cell Value being
equal to "S" with any colour.

 

[David Biddulph]

With Cell B2 active, CF/ Formula Is:
=WEEKDAY(--(B$1&$A2),2)>=6

 

[JH]

Thanks to all for your help.
--
JH

With Cell B2 active, CF/ Formula Is:
=WEEKDAY(--(B$1&$A2),2)>=6