multi level conditional formatting
 

Hi,

I am trying to figure out how to apply 2 conditions to a single cell. It's
for a scorecard type tracking sheet using a number rating scale to represent
the status.

I want to do both a fill color to represent status (Red, Yellow, Green) and
a directional arrow icon for tracking the trend. I can easily do both
independently using the conditional formatting rules, but get stuck trying to
get them both to work together.

Bascially each color would have 3 arrows associated with it.

Red Fill + up arrow, or down Arrow, or across arrow
Yellow Fill + up arrow, down Arrow, or across arrow
Green Fill + up arrow, or down arrow, or across arrow

any ideas how to do this or an easier way to set something like this up?

multi level conditional formatting
 

Goto Conditional formatting|New Rule
Within the 'New Formatting rules' window follow the below steps

1. Select 'Format only cells that contain' to define the cell color
2. Select 'Format all cells based on their values' and select 'Format
style-Iconsets' and define the value range

If this post helps click Yes
--------------
Jacob Skaria


"Sirpent0r" wrote:

Hi,

I am trying to figure out how to apply 2 conditions to a single cell. It's
for a scorecard type tracking sheet using a number rating scale to represent
the status.

I want to do both a fill color to represent status (Red, Yellow, Green) and
a directional arrow icon for tracking the trend. I can easily do both
independently using the conditional formatting rules, but get stuck trying to
get them both to work together.

Bascially each color would have 3 arrows associated with it.

Red Fill + up arrow, or down Arrow, or across arrow
Yellow Fill + up arrow, down Arrow, or across arrow
Green Fill + up arrow, or down arrow, or across arrow

any ideas how to do this or an easier way to set something like this up?

multi level conditional formatting
 

Thanks Jacob,

I think it's not quite that easy. That is where i ran into problems with the
way the icon arrows are defined as ranges ( or =) and what I am trying to
show. I couldn't find a way to map a particular icon arrow to a multiple
cases per color shading for each cell.

To explain this better, here is what i would like to do. There may be a
better way to do this so I'm open to other ways to think about this as well.

I'll base this on a number scale to show what i want to try and do using 3
numbers for each color and icon.

1 = Red + down arrow.
2 = Red + across arrow
3 = Red + up arrow
4 = yellow + down arrow
5 = yellow + across arrow
6 = yellow + up arrow
7 = green + up arrow
8 = green + across arrow
9 = green + up arrow

any tips how to best do something like this?









"Jacob Skaria" wrote:

Goto Conditional formatting|New Rule
Within the 'New Formatting rules' window follow the below steps

1. Select 'Format only cells that contain' to define the cell color
2. Select 'Format all cells based on their values' and select 'Format
style-Iconsets' and define the value range

If this post helps click Yes
--------------
Jacob Skaria


"Sirpent0r" wrote:

Hi,

I am trying to figure out how to apply 2 conditions to a single cell. It's
for a scorecard type tracking sheet using a number rating scale to represent
the status.

I want to do both a fill color to represent status (Red, Yellow, Green) and
a directional arrow icon for tracking the trend. I can easily do both
independently using the conditional formatting rules, but get stuck trying to
get them both to work together.

Bascially each color would have 3 arrows associated with it.

Red Fill + up arrow, or down Arrow, or across arrow
Yellow Fill + up arrow, down Arrow, or across arrow
Green Fill + up arrow, or down arrow, or across arrow

any ideas how to do this or an easier way to set something like this up?

multi level conditional formatting
 

one correction,

7 should = Green + down arrow.




"Sirpent0r" wrote:

Thanks Jacob,

I think it's not quite that easy. That is where i ran into problems with the
way the icon arrows are defined as ranges ( or =) and what I am trying to
show. I couldn't find a way to map a particular icon arrow to a multiple
cases per color shading for each cell.

To explain this better, here is what i would like to do. There may be a
better way to do this so I'm open to other ways to think about this as well.

I'll base this on a number scale to show what i want to try and do using 3
numbers for each color and icon.

1 = Red + down arrow.
2 = Red + across arrow
3 = Red + up arrow
4 = yellow + down arrow
5 = yellow + across arrow
6 = yellow + up arrow
7 = green + up arrow
8 = green + across arrow
9 = green + up arrow

any tips how to best do something like this?









"Jacob Skaria" wrote:

Goto Conditional formatting|New Rule
Within the 'New Formatting rules' window follow the below steps

1. Select 'Format only cells that contain' to define the cell color
2. Select 'Format all cells based on their values' and select 'Format
style-Iconsets' and define the value range

If this post helps click Yes
--------------
Jacob Skaria


"Sirpent0r" wrote:

Hi,

I am trying to figure out how to apply 2 conditions to a single cell. It's
for a scorecard type tracking sheet using a number rating scale to represent
the status.

I want to do both a fill color to represent status (Red, Yellow, Green) and
a directional arrow icon for tracking the trend. I can easily do both
independently using the conditional formatting rules, but get stuck trying to
get them both to work together.

Bascially each color would have 3 arrows associated with it.

Red Fill + up arrow, or down Arrow, or across arrow
Yellow Fill + up arrow, down Arrow, or across arrow
Green Fill + up arrow, or down arrow, or across arrow

any ideas how to do this or an easier way to set something like this up?