Conditional Formatting
 

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

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

Thanks!

Conditional Formatting
 

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

"Jason" wrote in message
...
Hi - can anyone help me to do the following...

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

Thanks!

Conditional Formatting
 

Thanks David,

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

"David Biddulph" wrote:

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

"Jason" wrote in message
...
Hi - can anyone help me to do the following...

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

Thanks!

Conditional Formatting
 

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


Gord Dibben MS Excel MVP

On Sat, 22 Mar 2008 17:18:01 -0700, Jason
wrote:

Thanks David,

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

"David Biddulph" wrote:

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

"Jason" wrote in message
...
Hi - can anyone help me to do the following...

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

Thanks!