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

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

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

--

"Greg Snidow" <(E-Mail Removed)> wrote in message
newsEAFADBA-682C-47FB-9E23-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> newsEAFADBA-682C-47FB-9E23-(E-Mail Removed)...
> >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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:0C8DB455-AD39-4923-A5C9-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> newsEAFADBA-682C-47FB-9E23-(E-Mail Removed)...
>> >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
>>
>>
>>

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

"PCLIVE" wrote:

> Try formatting E5 to General. It may not actually be zero.
>
> --
>
> "Greg Snidow" <(E-Mail Removed)> wrote in message
> newsEAFADBA-682C-47FB-9E23-(E-Mail Removed)...
> >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
>
>
>