Is it possible you have a round off? The cell might hold -0.00000000000009
but display 0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"myssieh" wrote in message
...
Hello, I am running office 2003.

I have a conditioinal format that says if cell is less than 0 to turn the
cell red. I have cells that are red and they have a value of 0. they are
NOT less than zero yet they are still turning red.

The adjacent cells have formulas. when I take out the formula and just
type
in the number the conditional formatting works correctly.

What would cause this? It is not happening on all cells. it si
sporadic...

Any insight would be greatly appreciated!!

Thanks again...

Myssie