how do i change cell text colour based on value in other cell

O

Oscarrot

i would like the text in a cell(s) to change colour when the data in another
cell is "0 or blank" and to another colour when the value is actually a
number.
 
M

Max

Assuming you want col B to be conditionally formatted based on col A's values
Select col B (with B1 active), apply CF using Formula Is:
Cond1: =OR($A1=0,$A1="")
Format to taste

Cond2: =AND(ISNUMBER($A1),$A1<>0)
Format to taste
Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 

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

Top