conditional format if cell value 0 pattern red value blank nothing

  • Thread starter Thread starter Guest
  • Start date Start date
G

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......
 
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
 
Back
Top