Conditional Formatting isnt working right
 

Condition 1
Cell value is Less than 0 then RED
Condition 2
Cell value is Greater than or equal to 0 then Green


this is what is in the conditional formatting boxes but for some reason
when the value in the cell =0 the cell turns red instead of green. The
value in the cell will always read a positive number because of in the
individual cell formatting I have this written in the custom menu
#,##,0.00;#,##,0.00

this conditional formatting works in other sheets but for some reason
it doesnt work in this particular sheet.

any ideas?

Thks

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=556505

Conditional Formatting isnt working right
 

I am not sure, but since you filled out the conditionnal formatting
form, why not change the cell formatting to "numbers" instead of
"custom"? Doesn't cost to try (unless there is another reason to use
custom...)


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=556505

Conditional Formatting isnt working right
 

tried that but then the negative numbers in the cell get displayed and
the font color goes red. I was doing it this way so the number would
be displayed in positive but with the red cell fill color so the
negative would be indicated by the red cell fill color.

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=556505

Conditional Formatting isnt working right
 

cell formatting has nothing to do with cell contents. You can format a cell
as "5" and it will always display 5 even if the value is -12. However, Excel
will treat the value as -12, not as 5. So, your conditional formatting is
not looking at the number format at all. If it's showing as RED, I'd guess
the cell is REALLY <0.
If that cell is E2, for example, put =E2<0 in another cell and you'll
probably see TRUE.

"changetires"
wrote in message
...

Condition 1
Cell value is Less than 0 then RED
Condition 2
Cell value is Greater than or equal to 0 then Green


this is what is in the conditional formatting boxes but for some reason
when the value in the cell =0 the cell turns red instead of green. The
value in the cell will always read a positive number because of in the
individual cell formatting I have this written in the custom menu
#,##,0.00;#,##,0.00

this conditional formatting works in other sheets but for some reason
it doesnt work in this particular sheet.

any ideas?

Thks

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=556505

Conditional Formatting isnt working right
 

Ok I tried what you said Bob and it did indeed show "true", so that
means the number isnt actually a true zero?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=556505

Conditional Formatting isnt working right
 

Try increasing the decimal places and see if the 0 is 0.0000000000000123 or
similar.

Is the "0" the result of a formula?


Gord Dibben MS Excel MVP


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 10:19:58 -0500, changetires
wrote:


Ok I tried what you said Bob and it did indeed show "true", so that
means the number isnt actually a true zero?

Ed

Conditional Formatting isnt working right
 

When I increase the decimal figure to about 29 places my 0 actually
reads
-0.00000000001940314575678900000........
I tried putting this value in the conditional formatting tool but it
will only work for one certain cell when I change cells so does this
long number so the conditions are changing. I am almost ready to
concede but not yet...

tks,

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile: http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=556505