Skip to content

Check If the Dates Are in Order

In this article, I will show you how to apply conditional formatting to identify dates that are not in chronological order.

The Example

Take a look at the following example.

You have a table showing the dates for the different stages of product orders.

The goal is to add conditional formatting to identify dates that are out of order. In other words, you want to highlight any dates in a later stage that come before the date listed in the previous stage.

The Conditional Formatting

Follow the steps below to apply the conditional formatting.

Select the range of dates in the later stages. There is no need to select the dates in the first stage.

Go to Home Conditional Formatting > New Rule.

Select the option to use a formula to determine which cells to format.

Enter the following formula.

= TopLeftCell_ofSelectedRange < OneCellToTheLeft
= C2 < B2

Click on Format.

Click on the Fill tab and select the color.

Then click OK and then OK. Excel highlights any dates that are out of order.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top