1

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 '17 at 13:39
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 '17 at 13:11

You must log in to answer this question.

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