conditional formatting - ajit

A

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
 
D

David Biddulph

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

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.
 
Top