Color scale conditional formatting based on another cell's value

**dtrimble** · 12-11-2013, 06:34 PM

In column F, I have a summary total number of customers that will be lost over a certain time at a given location (each row is a different location). In column G, I have the name of the rep responsible for those customers. I've used the Red-Yellow-Green color scale on column F to show in green which ones are losing no customers, and scale the gradient up to red to show which ones are losing the most. Easy enough.

I would like for the cells with the rep's names in column G to have the same color scale formatting as was assigned by Excel's conditional formatting rule to column F.

Is this possible? I know how to conditionally format the a cell based on another cell's value, but not to do it in an automatic color scale manner.

dt

**FDibbins** · 12-11-2013, 07:17 PM

If I understand you correctly, you used 1 of the built-in rules to apply the CF. These can only be used on the cell they apply to, not to otehr cells

To apply CF to cells other than the cell containing the criteria, you need to use the "use formula" rule, but then you loose the ability to use those color gradients and will have to create a new rule for each color

**dtrimble** · 12-11-2013, 09:09 PM

Originally Posted by FDibbins

If I understand you correctly, you used 1 of the built-in rules to apply the CF. These can only be used on the cell they apply to, not to otehr cells

To apply CF to cells other than the cell containing the criteria, you need to use the "use formula" rule, but then you loose the ability to use those color gradients and will have to create a new rule for each color

That's what I suspected, but wanted to confirm with those who know more than I do about this stuff--like you! So thank you, this is helpful. If not in solving my problem, at least I know it's not possible. There are dozens of gradient shades of color, so doing a new rule for each is not at all worth the effort.

**FDibbins** · 12-11-2013, 11:11 PM

Happy to help and thanks for the feedback

**Olly** · 12-11-2013, 11:25 PM

You can achieve similar formatting with VBA - I recently formatted a choropleth map with green:red sliding scale colours, based on pivot table values. Shout if you'd like some pointers, but it's not the most straightforward fix!

**johnharrison** · 10-09-2015, 05:08 AM

Hi,

I know this is an old thread, but I'm trying to the same thing, have a value displayed, but have a graded colourscale based on other cells values. Any pointers would be greatly appreciated.

Thanks

John

**etaf** · 10-09-2015, 05:46 AM

johnharrison
I would suggest you start a new thread of you own with the details required

This is solved, so very few people will view the thread - its only because I subscribed to the thread that I'm here

Also its always worth adding a sample

Make sure you have removed any private information, remember this is a public forum and so available to anyone
An example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

**j bliss** · 03-29-2024, 09:47 AM

I am interested in your offer of vba method for a choropleth map. My own goal is to apply the color map of table-1's 3-color scale conditional format overtop a same-sized table-2; where table-2's cell values are irrelevant or even blank.

**AliGW** · 03-29-2024, 09:49 AM

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar or even the same as this thread, we have a rule that you open your own thread on the issue and do not piggy back another member's thread.

Please see Forum Rule #1 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

Color scale conditional formatting based on another cell's value

LinkBack

Thread Tools

Display

Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Re: Color scale conditional formatting based on another cell's value

Thread Information

Users Browsing this Thread

Similar Threads

Conditional formatting entire row with graded color scale

Help with conditional formatting 3 color scale

Using color scale conditional formatting on columns

Conditional Formatting 3 color scale

conditional formatting with percentage color scale

Bookmarks

Bookmarks

Posting Permissions