conditional format if cell value 0 pattern red value blank nothing
 

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

conditional format if cell value 0 pattern red value blank nothing
 

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

On Nov 1, 11:32 am, Matt wrote:
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......