Conditional Formatting with Percents

[MikeB]

I'm trying to conditionally format a row of calculated values displayed at
percents with icons such that >100% - red light, 95 - 100% - yellow light,
<95% - green light. It seems that the Conditional Formatting Rules Manager
is inconsistently tagging values - one time it tags 105% as yellow, another
time it tags it as green.

Any insight would be appreciated.

 

[Teethless mama]

Condition1
Cell Value Is, less than, 0.95 (format as green)

Condition2
Cell Value Is, less than or equla to, 1 (format as yellow)

Condition3
Cell Value Is, greater than, 1 (format as red)

 

[David Biddulph]

First you need to look at what your formulae are, and the order in which
they are applied. Be careful with absolute and relative addressing.

Secondly you need to be sure of what is in each cell whose value you are
testing. Is it a straightforward number, or a number forwarded as a
percentage, or text?

If you are struggling to see what you've done wrong, break down the problem
a step at a time, looking at each part of each formula, and looking at the
inputs to that part of the formula.

 

[MikeB]

Thank you both. After reading Teethless mama's reply, I changed my
conditions to decimal numbers and that did the trick.

Thanks again.