Data Validation with Conditional Formatting in Excel

Data Validation with Conditional Formatting in Excel

Video • 6 minutes

Learning Objectives

  1. Discover how to implement data validation dropdown lists and conditional formatting in Excel. Establish how to organise and automatically highlight relevant data based on user-selected criteria.

    Lesson Description

    Discover the power of data validation and conditional formatting with our comprehensive lesson on creating dynamic dropdown lists in Excel. This lesson will guide you through setting up a user-friendly interface that automatically highlights corresponding rows in a table.

    We’ll provide step-by-step instructions on using formulas, data validation, and conditional formatting to enhance your Excel skills.Discover how to organise your data by creating a table, giving it a name for easy reference, and generating a unique list using the UNIQUE function. Don't worry if you don't have access to the UNIQUE function – we've got you covered with an alternative method.