Conditional formating not working
 

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

Conditional formating not working
 

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.

"Greg Snidow" wrote:

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

Conditional formating not working
 

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

--

"Greg Snidow" wrote in message
...
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.

"Greg Snidow" wrote:

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

Conditional formating not working
 

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

"PCLIVE" wrote:

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

--

"Greg Snidow" wrote in message
...
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.

"Greg Snidow" wrote:

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

Conditional formating not working
 

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" wrote in message
...
PCLIVE, right you are. it is actually .09. So how do I get around this
issue?

"PCLIVE" wrote:

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

--

"Greg Snidow" wrote in message
...
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.

"Greg Snidow" wrote:

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

Conditional formating not working
 

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

"PCLIVE" wrote:

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

--

"Greg Snidow" wrote in message
...
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.

"Greg Snidow" wrote:

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