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

dates and conditional formatting
 

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.


"JH" wrote:

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

dates and conditional formatting
 

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

"JH" wrote in message
...
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

dates and conditional formatting
 

Thanks to all for your help.
--
JH


"David Biddulph" wrote:

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

"JH" wrote in message
...
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