# Conditional formating not working

Greg Snidow
Guest
Posts: n/a

 11th Dec 2008
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
Guest
Posts: n/a

 11th Dec 2008
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
Guest
Posts: n/a

 11th Dec 2008
Try formatting E5 to General. It may not actually be zero.

--

"Greg Snidow" <(E-Mail Removed)> 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

Greg Snidow
Guest
Posts: n/a

 11th Dec 2008
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
> >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
Guest
Posts: n/a

 11th Dec 2008
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
> 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
>> >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

>>
>>
>>

Greg Snidow
Guest
Posts: n/a

 11th Dec 2008
=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
> >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

>
>
>

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Craig860 Microsoft Excel Misc 1 21st Oct 2009 09:09 PM Lester Lane Microsoft Access 2 9th Sep 2009 05:32 PM =?Utf-8?B?Q29ubmllSA==?= Microsoft Excel Worksheet Functions 1 19th Mar 2007 09:40 PM EagleOne Microsoft Excel Misc 11 25th Oct 2006 08:14 PM Jerry Eggleston Microsoft Excel Misc 2 9th Nov 2005 06:49 PM

Features