Try this:

B1: (leave it blank)
B2: =IF(MID(A1,5,6)+1=MID(A2,5,6)+0,"","07SA"&MID(A1,5 ,6)+1&" is missing")


"bprice" wrote:

Thank you so much for replying to my post. I tried this on my example and it
worked! the cells on my actual database have a mix of letters and number,
with which it didn't work. Does this factor change things? the actual
contents of my cells a

A1= 07SA100001
A2= 07SA100002
A3= 07SA100003
A4= 07SA100005 (flag this cell)
A5= 07SA100006

Do I need to format the cells a certain way, like as a number?

"BoniM" wrote:

Try this - select A2 thru the end of your list. (Don't include the first
item, impossible for it to be out of sequence...)
Choose, Format, Conditional Formatting, change Cell value is... to Formula
is...
and enter the following:
=A2<A1+1
(Exactly as above - be sure it's not =$A$2<$A$1+1)
click the format button, the patterns tab, and choose a color...
click ok to see A4 in your example flagged.

"bprice" wrote:

In Excel
How do I ID the specific cell that has fallen out of sequence in a list?
Example:

A1= 1
A2= 2
A3= 3
A4= 5 (flag this cell because the number "4" is missing)
A5= 6

Do I use a formula or is there a menu option I can use?