View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MikeB MikeB is offline
external usenet poster
 
Posts: 9
Default 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