Conditional Formatting

[Jason]

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

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

Thanks!

 

[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