Noxqss38242
Board Regular
- Joined
- Sep 15, 2017
- Messages
- 223
- Office Version
- 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!
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!