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.
--
David Biddulph

"MikeB" wrote in message
...
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.
--
MikeB