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...
<tbody>
</tbody>
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>