Conditional Formatting

Thread view:

Thread rating:

Jason - 21 Mar 2008 18:25 GMT

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

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

Thanks!

David Biddulph - 21 Mar 2008 18:59 GMT

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

> Hi - can anyone help me to do the following...
>
> A1 = Sat
> A2 = Turn cell grey if A1=Sat.
>
> Thanks!

Jason - 23 Mar 2008 01:18 GMT

Thanks David,

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

> In A2, CF/ Formula Is (not Cell Value Is):
> =A1="Sat"
[quoted text clipped - 8 lines]
> >
> > Thanks!

Gord Dibben - 23 Mar 2008 03:24 GMT

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

Gord Dibben MS Excel MVP

>Thanks David,
>
[quoted text clipped - 13 lines]
>> >
>> > Thanks!