conditional formatting - ajit

[Ajit Munj]

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

 

[David Biddulph]

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

 

[Ajit Munj]

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

 

[David Biddulph]

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.