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