Here is what I have.

    E16 has a value of 97%

    D16 has a value of 97%

I have a conditional formatting rule:

    Cell value < $D$16

    Applies =$E$16

    Format (turn text red)

The number in E16 is red when It should be black because it is not less than.

Why is the number red?

• Moved by Fei XueMicrosoft contingent staff Friday, February 20, 2015 5:38 AM

Hi,

I agree with John, this issue may be due to the numerical precision, try to check the value of cells. And then please let us know if you would like further assistance.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"