ActiveX control with conditional formatting possible?

Noxqss38242

Board Regular
Joined
Sep 15, 2017
Messages
223
Office Version
  1. 2016
Is there a way to use ActiveX control to toggle between how conditional formatting is applied? Or anyway that is quicker than manually doing this.

Range is B26:R36

Currently the conditional formatting is color scaled vertically for each column
I also want to run the color scale as a whole but going back and forth from vertical only to whole range is time consuming as there are multiple tabs which if a solution is found I can apply to more than just this one.

Thanks!
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Okay, I found a partial solution using Form controls instead of ActiveX controls however...
The graded color scale must be able to be manually placed "use a formula to determine which cells to format" instead of using "color scales" as the condition to highlight is based off the Form Control button.

So, is there a formula that mimics the graded color scale so eloquently?
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,044
Members
448,543
Latest member
MartinLarkin

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