Dynamic Conditional Formatting With Option Buttons without VBA

#ConditionalFormatting #FormControls
Hello Friends,
In this video, you will learn how to create 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.

Download the practice file from below link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[sarojdas]

excel n PBI learner can be incomplete without watching your video, you r best sir, learning lots from you.

[NikonCrayzee]

Fantastic video mate - great work and tutorial!

[UpExcel]

Excellent idea to use this combination of option buttons and conditional formatting. Great for a dashboard I'd say. You always have great ideas for using Excel features I think. 👍📊📈😀

[axlwrosess]

Great stuff bud as always, I did saw the error before it happen...thx for shearing

[kunalvanti]

Innovation is good.. Try to add value.. While selecting radio buttons

[upgradetechnicalskills]

Hi sir great things which I have learn today.
I would like to know it can possible to get text by conditional format

[tienngotk]

I dont have any experience in VBA, but it look so great

[bhaskarrammaringanti]

In mobile where can we find this options

[priyankak]

Can any one help, me I am trying this since Morning 5 AM its getting mixed with all bars. When I create first on heat map it shows correct but when i click on other buttons it shows in green color...

Please help me

[priyankak]

Still its showing green color - Help Please PK @PK

[bhaskarrao]

Sir I have a sheet having three things in three rows (1. Quantity 2. Amount 3. Check marks{√}) for different columns items with a merged cell of all three rows for a date. Now i want to transfer these data in other sheet for a regular dates in routine works with the correct marks (√). So please make vba code on this. You will be highly appreciated.