From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Unlock the full course today

Join today to access over 25,200 courses taught by industry experts.

Create and manage custom conditional formatting rules

Create and manage custom conditional formatting rules - Microsoft Excel Tutorial

From the course: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) Cert Prep

Start my 1-month free trial Buy for my team

Create and manage custom conditional formatting rules

“

- [Instructor] Conditional formatting applied to cells will change the cell appearance if specific criteria is met. Now, there are some great built-in conditional formatting rules that we can use, but if you want to dive a little deeper into your data and create your own rules using operators, such as greater than, less than, or equal to, you're really going to enjoy this video. Let's take a look at our 0307 conditional formatting worksheet. Our profit loss statement has a list of all of our products for the first half of the year and how they're doing in sales. In cell D3, I've created a data validation rule and used the product list in column A to create a dropdown menu for people to choose a product from. Our next step for conditional formatting will be to create a rule so when someone selects Canino, for instance, it'll come down and highlight that entire row. Let's begin by selecting all of our information.…

Contents