Excel 2007 Conditional Format

[Spraggs]

Hello All,
I want to conditional format cella A1 & A2

CF cell A1 if formula returns Red
CF cell A2 if formula in A1 returns Red

I need this to work wwith excel 2003 as well.

Regards Jase

 

[MisterBate5]

You'll need to give us a bit more info. What're the values you expect in cell A1 that would make it Red? And then if cell A2 goes Red at same time as A1, you just apply the same conditional formula to cell A2, making sure that the CF in both cases reference $A$1.

 

[GlennUK]

... are you saying that if cell A1 contains a formula ( rather than a value ), then both A1 and A2 should turn red?

 

[Spraggs]

Apologies guys, not explained very well, tried to simplify but badly.
Try again.
Cells B2:W2 have a date in the format 01/01/2011
Cells B3:W3 have the =B2 etc and custom formatted ddd
Cells B4: W4 have a customer ref: No.

I want B3:B4 to be in a formatted colour if the date in cell B2 is a Saturday etc.

Thanks Jase

 

[MisterBate5]

Use the following as the formula in your format condition for cells b3:b4

=WEEKDAY(B$2,2)=6