Flag Out of Sequence Dates in an a Column

[strusty]

I have Excel 2010 on Windows 7 Professional and need help with a report that I run daily. I think I am proficient in Excel, but haven't been able to figure this one out. I check Microsoft Help but no luck.

So here is the issue.

I have various clusters of dates in column O that indicates the date we received the product in. Each Row is a different storage bin. Each cluster is a different item which is separated by an empty row. I want to be able to flag my date column when the dates are out of order. Is there a formula I can use or can I use conditional formatting or anything else I am not thinking about that will help me flag out of sequence receipt dates??? Example below...

ITEM 1	QTY	WT	DT RECD
BIN 1			1/2/14
BIN 2			2/1/14
BIN 3			3/5/13
ITEM 2
BIN 4			1/2/14
BIN 5			12/9/13
ITEM 3
BIN 6			5/4/14
ITEM 4
BIN 7			9/10/14
BIN 8			9/10/14
BIN 9			8/9/14
BIN 10			9/10/14

<tbody>
</tbody>

 

[tusharm]

So, in your example which rows do you want flagged? And why?

I have Excel 2010 on Windows 7 Professional and need help with a report that I run daily. I think I am proficient in Excel, but haven't been able to figure this one out. I check Microsoft Help but no luck.

So here is the issue.

I have various clusters of dates in column O that indicates the date we received the product in. Each Row is a different storage bin. Each cluster is a different item which is separated by an empty row. I want to be able to flag my date column when the dates are out of order. Is there a formula I can use or can I use conditional formatting or anything else I am not thinking about that will help me flag out of sequence receipt dates??? Example below...

ITEM 1	QTY	WT	DT RECD
BIN 1			1/2/14
BIN 2			2/1/14
BIN 3			3/5/13
ITEM 2
BIN 4			1/2/14
BIN 5			12/9/13
ITEM 3
BIN 6			5/4/14
ITEM 4
BIN 7			9/10/14
BIN 8			9/10/14
BIN 9			8/9/14
BIN 10			9/10/14

<tbody>
</tbody>

 

[suremac]

You could use this,

=IF( AND(O2 <> "", O2-O1<0), 1, 0)

, starting in row two of any column (except those with data in it). It will place a value of 1 in the row adjacent to the date that is out of order. Then, you could highlight rows with 1 in them.

 

[strusty]

Awesome! Thanks for speedy response!