Conditional Formatting: 2 Independent rules for arrow shape and color

z3115

Board Regular
Joined
Nov 1, 2013
Messages
71
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!
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Have you tried "Format Cells Based On Thier Value" using Icon Sets - Arrows, then select the color?
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,287
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top