conditional format if cell value 0 pattern red value blank nothing

[Guest]

I tried conditional formatting. If cell value 0 pattern red color. If cell
value blank no changes. I have entire column with value some 0 value some
blank. conditional format equal to 0 pattern red is working fine but blank
cell also replacing with red color. I dont want blank cell to replace. I
want blank cell as it is.

Any way......

 

[Pete_UK]

Excel often evaluates these to be the same. You will need to change
the CF conditions to Formula Is rather than Cell Value Is, then enter
this formula:

=AND(ISNUMBER(A1),A1=0)

assuming the cell is A1.

Hope this helps.

Pete