Peo Sjoblom,

What do you mean by "break out the numbers?" and what does your last
sentence mean?

"Peo Sjoblom" wrote:

Formatting makes no difference, besides you cannot format text which is what
you got.
You would need to break out the numbers and assuming that they always start
with 07SA
you can use

=--MID(A1,5,255)

copy down the do whatever you did that worked on this column instead


--


Regards,


Peo Sjoblom


"bprice" wrote in message
...
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?