Conditional formatting Problem

[myssieh]

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

 

[Bernard Liengme]

Is it possible you have a round off? The cell might hold -0.00000000000009
but display 0
best wishes

 

[myssieh]

That is the problem... there is a .05. The cell is being rounded up. How
can I get excel to ignore these and only look at the value of the cell
rounded up.

 

[David Biddulph]

Either use the ROUND function in your cell formula, or include the ROUND
function in your CF formula.