Checking that dates are in sequential order with Excel Conditional Formatting Formula

Question: I’m trying to figure out how to use conditional formatting to check if the date column is in sequential order and highlight a cell if it is not. Answer: Here is how you can create a conditional formatting rule which would highlight dates or numbers out of sequence. Assuming your first date is in A1 and the rest below them:

• Select all dates in the range from A2 down
• In conditional formatting, select the option to create conditional formatting based on a rule
• Enter this formula =A2

  When you OK that rule you will see that all dates which are not in sequence compared to the previous one will be formatted     I first published this answer on MrExcel forum