I want all values entered in a particular column to be blue or red if a cell
in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should
be blue
thanx
ajit
--
Knowledge is Power

Format/ Conditional Formatting/ Formula is:
=COUNTIF(C:C,"Sat")>0
and choose your format.
Add: then include similar formula for Sun
--
David Biddulph

"Ajit Munj" <(E-Mail Removed)> wrote in message
news033D7CF-FBAE-4A80-A5A9-(E-Mail Removed)...
>I want all values entered in a particular column to be blue or red if a
>cell
> in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C
> should
> be blue
> thanx
> ajit
> --
> Knowledge is Power

It's working, Thanx. But did not get formula. Why there is >0?
--
Knowldege is Power


"Ajit Munj" wrote:

> I want all values entered in a particular column to be blue or red if a cell
> in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C should
> be blue
> thanx
> ajit
> --
> Knowledge is Power

If you want to reply to someone, it might be wise for you to quote at least
the relevant part of the message to which you were replying.
As it is, we don't know what you're talking about.
--
David Biddulph

"Ajit Munj" <(E-Mail Removed)> wrote in message
news:79D429F2-C03E-4988-B17E-(E-Mail Removed)...
> It's working, Thanx. But did not get formula. Why there is >0?
> --
> Knowldege is Power
>
>
> "Ajit Munj" wrote:
>
>> I want all values entered in a particular column to be blue or red if a
>> cell
>> in that column is Sat or Sun e.g. if cell c3=Sat. all values in col C
>> should
>> be blue
>> thanx
>> ajit
>> --
>> Knowledge is Power