Conditional formating not working

[Greg Snidow]

Greetings all. I have a formula in E3, =SUM(D6:F6). I have a formula in E4
which is to sum three other cells. In E5 I have formula =E4-E5. I have
conditional formating on E5 as cell value is equal to 0, change background
color to green. If the value of E5 is 0, based on the formula in it, the
conditional formatting does not work. However, if I manually type in 0, then
it turns green. Does anyone know why this would be happening? All cell
involved are formattted as number with no decimals.

Greg

 

[Greg Snidow]

I think I'm on to something. If I go to a blank cell and enter =E5=0, then I
get FALSE, when the value of E5 is seemingly 0 and is based on the formula
=E4-E5. If, however, I manually type in 0, then =E5=0 returns true, and the
conditional format works. So, what is it about E4-E5 that, even when the
answer is 0, returns a value that Excel does not think is 0? I'm flumoxed.

 

[PCLIVE]

Try formatting E5 to General. It may not actually be zero.

--

 

[Greg Snidow]

PCLIVE, right you are. it is actually .09. So how do I get around this issue?

 

[PCLIVE]

You should probably try to figure out why you have a decimal since you
earlier said that there were no decimals. However, if this should be
rounded, then:

=ROUND(E4-E5,)

Hope this helps,
Paul

--

 

[Greg Snidow]

=ROUND(E4-E5,0) worked. Thanks for the tip.

Try formatting E5 to General. It may not actually be zero.