From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create and manage custom conditional formatting rules

Create and manage custom conditional formatting rules

From the course: Cert Prep: Excel Expert - Microsoft Office Specialist for Office 2019 and Office 365

Start my 1-month free trial

Create and manage custom conditional formatting rules

“

- Conditional formatting applied to cells will change the cell appearance if specific criteria is met, and 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 then you're really going to enjoy this video. Let's take a look at our custom conditional formatting workbook. On our profit and loss worksheet we have profit and loss for the first half of the year. We have all of our products listen in column A and I have created a data validation rule in D3 and inserted a list of all of our products for people to choose from. Right now when they select a product, nothing happens. But what if we created a custom conditional formatting rule that highlighted that entire record when the product was selected? Your conditional formatting is located on your home tab. We'll…

Contents