ActiveX control with conditional formatting possible?

Noxqss38242

Board Regular
Joined
Sep 15, 2017
Messages
139
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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Noxqss38242

Board Regular
Joined
Sep 15, 2017
Messages
139
Office Version
  1. 2016
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?
 

Forum statistics

Threads
1,136,303
Messages
5,674,968
Members
419,537
Latest member
ucatchy

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
Top