Changing color of Conditional Formatting Data Bars based on another cell value

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
122
Hi all Excellers,

I have a very simple question but may be a bit of a challenge.

I made a data bar in the conditional formatting under Styles.

The rule type used is "Format all cells based on their values"

The resulting bar comes up based on the value of the cell and the minimum number and a maximum number, which is what i want as far as a bar. Example if the cell value is 7 and the min is 0 and the max is 10, then it shows a bar that covers 70% of the cell. Great!!!

The only requirement that I need of that bar is that I need the color of the bar be based on the value of another cell.
For example, between 0% and 30%, the color must be Red, between greater than 30% and 70% the color must be yellow, between greater than 70% and 100 the color must be green.

Any way of achieving a dynamic coloring of the data bars based on percentages in another cell?

Many thanks in advance Excellers!!!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,213,495
Messages
6,113,992
Members
448,538
Latest member
alex78

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