LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
using percentages in conditional formatting Rolando Excel Worksheet Functions 1 May 29th 09 12:20 AM
Excel 2007 - Conditional Formatting Problem with Percentages Caros Excel Worksheet Functions 3 March 12th 09 06:47 PM
Conditional Formatting with Percentages - only 2 of 3 working Roady Excel Worksheet Functions 3 March 16th 08 11:16 PM
Apply conditional formatting to cells formatted as percentages? patgal77 New Users to Excel 1 April 18th 07 08:47 PM
Conditional Formatting and Percentages of a set target [email protected] Excel Programming 0 January 30th 07 07:05 PM


All times are GMT +1. The time now is 01:00 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"