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

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Have you tried "Format Cells Based On Thier Value" using Icon Sets - Arrows, then select the color?
 
Upvote 0

Forum statistics

Threads
1,223,236
Messages
6,170,917
Members
452,366
Latest member
TePunaBloke

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