Suppose your check numbers are in column A, starting in row 2.
Put the following formula in B3 and copy down as far as you need
to go.

=IF(A3<A2+1,"*","")

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com





"Judi Mason" wrote in
message
...
I have three columns of info. Date, Check #, and $ amount.
I have a straight list in order of check#. There are several
occurances
where there is a gap in the check # sequence.
Is there anyway to put a "*" like on a bank statement each time
there is a
gap in the check # sequence??