LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Excel 2010 Conditional Formatting

I am trying to use this ingenious method of creating a dashboard that will display a red, amber and green setting based on the value of data that is compiled compared against static %. I have figured out the formula to do the conditional formatting but here is my dilemna:

I want all 3 fields to be black but when the condition is violated, or met, that particular cell will turn red, amber or green.

i.e.
Threshold <=15% 28% 33% 25.00%
Target <=25% 25%
Stretch <=15% 15%

so in the example above the 25% meets the Target which will produce an amber color. Imagine that in an excel sheet the 25% is lined up in the middle row. The above cell and below should be all black. I have an overlay of a real traffic light that when put over the top of the cells it will "light up" based on the value.

So all in all I want all 3 cells to have a black fill but when the value is met it either the top (red), middle (amber) or bottom (green) cell should turn that color while the other 2 stay black.

Any help would be great!

Thanks!
 
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
alternate rowshading using conditional format excel 2007/2010 Ludo Excel Programming 6 July 16th 12 05:10 PM
Excel 2010 to auto-generate an email to recipients in outlook 2010 dmcmillo Excel Programming 0 June 14th 12 10:12 PM
Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook [email protected] Excel Programming 0 April 25th 12 09:59 PM
Help with conditional formatting in Excel 2010 Ian R[_4_] Excel Worksheet Functions 8 February 14th 12 01:08 AM
little off topic, but with excel 2010 conditional formatting properties will be accessible through vb Gary Keramidas Excel Programming 0 August 14th 09 03:46 PM


All times are GMT +1. The time now is 05:22 AM.

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"