Advanced Conditional Formatting in Excel Tutorial

Learn how to use advanced conditional formatting in Microsoft Excel. In this step-by-step tutorial we will be creating dynamic row highlighting based on the selection from the drop down lists using conditional formatting.

For that we will be using the month formula. So in the very beginning we need to understand that how it works & what trick we can play with the MONTH function to get our desired results.

Then latter on we will see how to highlight the rows dynamically between a given range.

Timeline:-
00:00 - Intro
00:53 - Advanced Conditional Formatting
05:10 - Highlighting Rows in a range
07:20 - Wrap up