Conditional Formatting (IF) Using Dates on Excel

January 2018

Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules.

The rules can be based on number values or ranges, text values, or even dates. This FAQ will get into how you can conditionally format your data based on dates.

How To Conditionally Format Excel Data Using Dates

Highlight a row that you wish to format, and select Conditional formatting from the Ribbon menu.

Next, click Manage rules > New rule.

Create the rule =$B$2>TODAY() followed by any color you'd like. In this example, you have selected cell B2 and have decided that, when the date in cell B2 is later than today, the line that you have selected will be formatted in your selected color.

To apply this example to your case, you can modify the cell and choose between >, <, and = to define the formatting.

Image: Microsoft.
Published by aakai1056. Latest update on November 22, 2017 at 06:04 PM by owilson.
This document, titled "Conditional Formatting (IF) Using Dates on Excel," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Excel - Count rows where 2 conditions are true
Excel - A macro to change the color of row on condition