Conditional Formatting

[Jason]

Hi - can anyone help me to do the following...

A1 = Sat
A2 = Turn cell grey if A1=Sat.

Thanks!

 

[David Biddulph]

In A2, CF/ Formula Is (not Cell Value Is):
=A1="Sat"
and choose your grey format.

 

[Jason]

Thanks David,

How can I add an or function?
=A1="Sat" or "Sun"

 

[Gord Dibben]

=OR($A$1="Sat",$A$1="Sun")


Gord Dibben MS Excel MVP