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!
|