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