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

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)


"MikeB" wrote:

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

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

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

Thanks again.
--
MikeB


"MikeB" wrote:

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