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