Prev: creating macros
Next: FORMULA BAR DISAPPEARED IN 2007, HOW DO I RESTORE PLEASE?
From: A Sunfire A on 26 Mar 2010 14:57
I have an inventory list with inventory tag #'s associated with it. I would
like Excel to indicate when a # in the sequence is missing.
From: Fred Smith on 26 Mar 2010 15:23
It depends on what you define as "missing", and how you want this indicated.
What I do is use a conditional format like:
=a2<>a1+1
and choose a highlight color.

Regards,
Fred

"A Sunfire" <A Sunfire(a)discussions.microsoft.com> wrote in message
news:AA814CEC-3D79-4C55-B99D-577B5C2DDAEB(a)microsoft.com...
>I have an inventory list with inventory tag #'s associated with it. I
>would
> like Excel to indicate when a # in the sequence is missing.

 | 
Pages: 1
Prev: creating macros
Next: FORMULA BAR DISAPPEARED IN 2007, HOW DO I RESTORE PLEASE?