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 6 hours 14 minutes ago

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?

I suspect this has to do with the number of digits. Just because you have 97% showing does not mean you have 97.000000000% It could very well be that E16 = 96.67% and D16 = 97.1%. E16 <D16

Hi Pippo24,

Thanks for posting in MSDN forum.

This forum is for developers discussing developing issues involve Excel application. Since the issue is more relative to then end-user, I would like to move it to Excel IT Pro Discussions forum to get effective response.

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Regards & Fei