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

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

 

[Jacob Skaria]

Check out the below link regarding conditional formatting based on another
cell.

http://www.contextures.com/xlCondFormat02.html

If this post helps click Yes

 

[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