Excel 2019 Bible

Chapter 17: Using Formulas with Tables and Conditional Formatting

17

Highlighting dates based on a due date

The example shown in Figure 17.13 demonstrates that you can conditionally format dates

that are past due by a given number of days. In this scenario, the dates that are over 90

days overdue are highlighted with a red background.

FIGURE 17.13

You can conditionally format dates based on due date.

To build this basic formatting rule, follow these steps:

1. Select the data cells in your target range (cells C4:C9 in this example), click the
   Home tab of the Excel Ribbon, and then select Conditional Formatting ➪ New Rule
   New Rule. This will open the New Formatting Rule dialog box shown in Figure 17.14.

FIGURE 17.14

Configure the New Formatting Rule dialog box to apply the needed formula rule.