Ignore rounding in conditional formation

[kstoneman]

Right now I have a condition that if the value is less than80 then use RED fill. My problem is whenthe cell value is 79.8; because of rounding, it displays 80 and no REDfill. The cell format is number with zerodecimal places. I want the cell fill toreflect no fill.<o></o>

 

[erik.van.geit]

Hi, welcome to MrExcel,

You need to see the difference between the DISPLAY and the REAL VALUE.

When I apply conditional format "lower than 80", it doesn't matter what the display of that cell is.
I've put 79.8 in a cell, set the NumberFormat to Number with 0 decimals and it's still red.
Click in any cell and write =A1 (change A1 to your cellreference). What do you see?

kind regards,
Erik