From the course: Excel for Mac Essential Training (Microsoft 365)

Unlock this course with a free trial

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

Manage conditional formats

Manage conditional formats - Microsoft Excel for Mac Tutorial

From the course: Excel for Mac Essential Training (Microsoft 365)

Start my 1-month free trial Buy for my team

Manage conditional formats

“

- [Instructor] After you have created one or more conditional formats, you can edit, reorder, and delete the rules as necessary. In this movie, I will show you how to manage the rules you have created. My sample file is 06_10_ManageConditions, and you can find it in the Chapter 6 folder of the exercise files collection. In this workbook, I have a single worksheet and on it I have a list of the daily order percentage. So I'm assuming that of customers that reach out to us that the number or percentage displayed here is the percentage of customers who ordered on a particular day. And I have conditional formats applied so that I can tell visually where each of the days fell based on the criteria that I created. And let's see what those criteria are by examining the conditional formats. I'll select the cells that have the rules applied, and those are B4 through B14. Then on the home tab of the ribbon, I'll click Conditional Formatting. And then at the bottom we have Manage Rules. And when…

Contents