View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amanda amanda is offline
external usenet poster
 
Posts: 12
Default highlight row if cell value equal zero

I am trying to use conditional formatting to highlight a row if value
in column E = 0.

I have tried highlighting the row and the selecting:

Format-Conditional Formating

Formula is =IF($E67=0)

then selcted color I would like to appear if formula is true.

But, it's not working.

Any ideas?

Thanks!