Conditional Formatting with Percents
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
|