Conditional formating not working as expected

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?

February 20th, 2015 2:01am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics