In this article, we have created Dynamic Conditional Formatting in Excel using Form Control Option Buttons. Conditional Formatting is changed in Heat Map (Color Scale), Data Bar and Traffic Lights according to the selection of Option button.
Dynamic Conditional Formatting in Excel
While selecting the Heat Map option button-

While selecting the Data Bar option button-

While selecting the Traffic Lights option button-

While selecting the None option button-

Visit our YouTube channel to learn step-by-step video tutorials