Dynamically Highlight Rows in Your Excel Dashboard

Показать описание

Dynamically Highlight Rows in Your Excel Dashboard

-- Video Notes and Resources --

1) Purchase the Excel Dashboard Toolbox at 20% off using discount code YOUTUBE20 -

Connect with me on Social Media:

-- Summary of this Excel Dashboard Tip --

In this Excel Dashboard tutorial I'll show you how to build a front end dashboard where every selection made by the user in a combo box will be dynamically highlighted using the INDEX formula and creating a custom conditional formatting formula. If you want to skip a step feel free to refer to the below:

The 3 Steps on how to create this excel dashboard:

Step # 1: Create your drop down selection box.

Step # 2 - Use the INDEX Formula to determine what selection is made in your drop down combo box.

Step # 3 - Apply conditional formatting using the value created by the INDEX Formula to determine what line to highlight.

#exceldashboard #conditionalformatting #index