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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

conditional if -ajit 3
Conditional Formatting of rows on a calendar 1
Multiple items selected multiple dependancies available 3
Find value based on two lookup values 2
Conditional Formatting - Excel 2003 2
count conditional days - ajit 6
Conditional Formatting 6
Excel does not accept text format! 0

Top