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

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.

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

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

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

If this post helps click Yes
---------------
Jacob Skaria


"Oscarrot" wrote:

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.

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

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
---
"Oscarrot" wrote:
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.