Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Performance Measures and Conditional Formatting
I have a matrix and in the matrix I have indicators. Directly below
all the indicators is the same matrix on the same sheet but filled in with monthly targets. I would like to link the conditional format to the target so when the data is entered it will change to either green, yellow, or red depending on whether it is 100%, 90-99.9%, or <90% within the set target. Any help would be great. Thanks. Ex. Data Indicator | Jan | Feb | March | ....... ------------------------------------------------------------- # of Tests | 10 | 9 | 8 | ------------------------------------------------------------- Targets Indicator | Jan | Feb | March | ....... ------------------------------------------------------------- # of Tests | 10 | 10 | 10 | ------------------------------------------------------------- Thanks, James |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Conditional Formatting Values | Excel Worksheet Functions | |||
Conditional Sum of Quarters | New Users to Excel |