Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting
Help! I am trying to produce some conditional formatting
in code. The conditions are 1-4 and apply to each city independently. The problem I am having is condition 3 where condition 1 must be met and the "or" in condition 3. Thanks! Conditions: Blue 1 Tracking Threshold -below 25 . Green 2 Normal -below 10% of the 5 year average and last year. Yellow 3 Caution -above 10% of either the 5 year average or last year. Red 4 High -above 25% for both 5 year average and last year. Example: ThisYear LastYear 5YAvg Vs.LYear Vs.5YAvg City1 21.2 7.3 14.0 190% 51%(Blue) City2 26.8 25.9 22.7 3% 18%(Yellow) City3 28.0 29.6 25.4 0% 3%(Green) There are six cities. Thanks Again! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |