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!

highlight row if cell value equal zero
 

Just use

=$E67=0

--
__________________________________
HTH

Bob

"amanda" wrote in message
...
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!

highlight row if cell value equal zero
 

Hi Amanda

Try the following for highlighting the entire row

1. Select on the row/s you want to hightlight
2. Go to Format and select Conditional Formatting
3. Choose FORMULA IS under Condition 1
4. Enter this formula =$E67=0
5. Click on Format Go to Pattern choose the color you want
6. Click Ok out all the way and you are done

or

Assuming that you want the range A67:E67 highlighted when cell E67=0

Select the row A67:E67
Goto FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=$E67=0

Click the Format button
Select the color you want
OK out


HTH
--
Pls click the Yes button below if this posting is helpful.

Thank You

cheers, francis



"amanda" wrote:

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!