Conditional formatting Problem

  • Thread starter Thread starter myssieh
  • Start date Start date
M

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
 
Is it possible you have a round off? The cell might hold -0.00000000000009
but display 0
best wishes
 
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.
 
Either use the ROUND function in your cell formula, or include the ROUND
function in your CF formula.
 
Back
Top