Using Items sequence numbers in order

[oam]

I work in a facility where items we process must be used in order by sequence number. The items are issued out of the storage room by scanning the sequence number(s) and the employee signing the issue log (see below for example log), there by taking possession of the item(s).
I would like to know, is it possible to have a formula or macro to look at the sequence number column to identify entries where items are issued out of sequence and have the cell in question change color there by alerting the manager to a problem? The column (E column) is quite long, as much as 4000 rows in the sequence number column. In addition to the Issue (out to employees), sometimes the employee(s) are unable to complete all the items issued to them and the items are returned to the storage room shown in the log as Rcv. (back to storage room) to be issued to the next shift.

Thank you for any assistance you can provide.

Storage Room Log.jpg

[ranman256]

Send the workbook and I'll take a crack at it.

[Bob Phillips]

Use conditional formatting with a formula of

=E5<E4

and format as you desire

[oam]

ranman256,

Attached is a copy of the balance sheet

Thanks for any and all help

[snb]

Conditional formatting for E5:E6000:

=MOD(ROW(E5);2)*(E5-E4<>1)=1

[ranman256]

oam, I had a full working macro, but I was still in .xlsx and saved it and excel erased it because it wasnt a .xlsm! #$@!
I'll try to recreate.

[ranman256]

StorageRoomBalance2.xlsm

Here is the basic macro.
I did not recreate the logic for errors (see the select statement) but you can do that.

[oam]

I want to thank all of you for helping me solve my problem, this is the best Excel forum!