How to use conditional formatting to check if the date column is in sequntial order

[Jetpilot]

I'm trying to figure out how to use conditional formatting to check if the date column is in sequntial order and highlight one square if it is not.

here is an example of what it would look like
[TABLE="width: 59"]
<colgroup><col></colgroup><tbody>[TR]
[TD]6/16/1998
[/TD]
[/TR]
[TR]
[TD]6/17/1998[/TD]
[/TR]
[TR]
[TD]6/18/1998[/TD]
[/TR]
[TR]
[TD]6/17/1998
[/TD]
[/TR]
[TR]
[TD]6/21/1998[/TD]
[/TR]
[TR]
[TD]6/23/1998
[/TD]
[/TR]
[TR]
[TD]6/24/1998[/TD]
[/TR]
[TR]
[TD]8/10/1998[/TD]
[/TR]
[TR]
[TD]8/11/1998[/TD]
[/TR]
[TR]
[TD]8/12/1998[/TD]
[/TR]
[TR]
[TD]8/13/1998
[/TD]
[/TR]
[TR]
[TD]8/19/1998[/TD]
[/TR]
[TR]
[TD]9/17/1998[/TD]
[/TR]
[TR]
[TD]9/28/1998[/TD]
[/TR]
[TR]
[TD]10/8/1998[/TD]
[/TR]
[TR]
[TD]10/9/1998[/TD]
[/TR]
[TR]
[TD]5/20/1998[/TD]
[/TR]
</tbody>[/TABLE]

 

[francoisdublin]

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<A1 and choose a conditional format

When you OK that rule you will see that all dates which are not in sequence compared to the previous one will be formatted