Chapter 17: Using Formulas with Tables and Conditional Formatting
17
Highlighting days between two dates
Some analysis requires the identification of dates that fall within a certain time period.
Figure 17.11 demonstrates how you can apply conditional formatting that highlights dates
based on a start date and end date. As the start and end dates are adjusted, the conditional
formatting adjusts with them.FIGURE 17.11
You can conditionally format dates that fall between a start and end date.To build this basic formatting rule, follow these steps:- Select the data cells in your target range (cells E3:E18 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
F i g u r e 17.12.