View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sherm H.[_2_] Sherm H.[_2_] is offline
external usenet poster
 
Posts: 1
Default Conditional Formatting of Percentages

I have a spreadsheet with 12 rows (one for each month), and 3 columns:
Incidents Closed, Closed on Time, and Percentage Closed on Time. The data in
the % Closed on Time is formula (=IF(E15=0,"",E16/E15).

I'm trying to use Conditional Formatting Icon Sets, Traffic Signals as
follows: 90% = Green, 80-89% =Yellow, and Below 80% = Red. I can't get the
Icon Sets to work correctly, getting some percentages with the incorrect
color, as a new month'e data is acced to the sheet. I have the Rules set up
as indicated above, and using the percent Type in the Rules. If any of the
percentage values change, the colors then get all screwed up. What am I
doing wrong?