Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using percentages in conditional formatting | Excel Worksheet Functions | |||
Excel 2007 - Conditional Formatting Problem with Percentages | Excel Worksheet Functions | |||
Conditional Formatting with Percentages - only 2 of 3 working | Excel Worksheet Functions | |||
Apply conditional formatting to cells formatted as percentages? | New Users to Excel | |||
Conditional Formatting and Percentages of a set target | Excel Programming |