I have a cell, the value is 90.90,

I setup a continual highlighting for different value, one is suppose to be greater than or equal to 99.90.

however I don't get this one to work as 99.90 is automatically change to 99.9 (even though the cell remain to 99.90)

How can I fix it?

Thanks in advance

  • This is a mathematical formula, 99.90 is the same as 99.9
    – hdrz
    Jun 20, 2017 at 13:39

1 Answer 1


I tried this and even though 99.90 is changed to 99.9 in the conditional highlighting rule, it works perfectly even if the value in the cell is 99.90. enter image description here

  • I have the exact same settings but its wasn't working and keep give me the colour of the wrong data, but for some reason it now in the correct colour (I didn't zero change) anyway. thank you.
    – Kevin
    Jun 22, 2017 at 13:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .