Hi All,
I'm trying to do some conditional formatting that appears to be more complex than what excel wants to do:
I have a set of about 10 metrics. For each metric I want to do the following:
A) If the metric went up or down from the prior period, I want to see an arrow going up or down (or flat if it stayed the same)
B) For each metric I have 3 manually set zones (good, neutral, bad). If the metric is in the good zone I want the metric to be green, yellow for the neutral zone, red for the bad zone.
So ultimately there are 9 possible options: 3 arrow directions (up, down, or flat/sideways) and 3 color options (red/yellow/green).
Is there a way to tie the color of the shape to 1 rule, and then tie the direction of the arrow to another rule? Thanks for the help!
I'm trying to do some conditional formatting that appears to be more complex than what excel wants to do:
I have a set of about 10 metrics. For each metric I want to do the following:
A) If the metric went up or down from the prior period, I want to see an arrow going up or down (or flat if it stayed the same)
B) For each metric I have 3 manually set zones (good, neutral, bad). If the metric is in the good zone I want the metric to be green, yellow for the neutral zone, red for the bad zone.
So ultimately there are 9 possible options: 3 arrow directions (up, down, or flat/sideways) and 3 color options (red/yellow/green).
Is there a way to tie the color of the shape to 1 rule, and then tie the direction of the arrow to another rule? Thanks for the help!