excel for mac highlight row conditioning formating

So in this lesson, we'll look at how to apply the formatting to cells containing all dates in the past, not just those in the last month. These are simple and easy to apply but the problem for our scenario is that there isn't a built-in conditional formatting rule that applies to all dates in the past - the best you can do with the built-in rules is to format cells containing dates that are in the last month. Note that Excel's Conditional Formatting feature includes an option to highlight dates according to a range of pre-configured conditional formatting rules. Second, it extends the criteria for the formatting rule so that only those tasks where the due date is in the past AND the task is still open will be highlighted - at a glance, we can tell which tasks are overdue and need attention.First, it shows you how to apply a format to a cell containing a date where that date is in the past - this allows us to see which of the tasks in our project are overdue.

This lesson uses a Project Checklist example to demonstrate how to use Conditional Formatting. You can even use the value of other cells in the worksheet as part of your conditional formatting criteria.

It allows you to apply formatting to cells or ranges of cells based on criteria that you can choose. Excel's Conditional Formatting feature is incredibly powerful.

Excel for mac highlight row conditioning formating