View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default 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......