Excel Conditional Formatting for a Date
Adding conditional formatting to a cell in Excel allows you to apply different formatting options, such as color, to a cell or cells that contain dates.
Excel has several built in options that allow you to easily add formatting so that a date that has past - such as overdue bills is easily spotted. Similarly, a date in the future can also be highlighted using different background and/or font colors.
To find dates that do not match the pre-set choices, you can add new conditional formatting rules that use date formulas to find the information you are after.
Example: Adding conditional formatting to a date in Excel
- Click on cell C1 to make it the active cell.
- Click on the Home tab.
- Click on the Conditional Formatting icon on the ribbon to open the drop down menu.
- Choose Highlight Cell Rules > A Date Occurring... to open the conditional formatting dialog box.
- Click on the down arrow of the date options drop down menu (left side) to open the list.
- Select In the last 7 days from the list.
- Click on the down arrow of the format options drop down menu (right side) to open the list.
- Select Light Red Fill with Dark Red Text from the list.
- Click OK to accept the changes and close the dialog box.
- Type yesterday's date in cell C1 and press the ENTER key on the keyboard.
- Cell C1 should be formatted with a light red background color and dark red text since yesterday's date occurred within the last seven days.