Excel formula question

[Leroy Frazier]

I am putting together an excel spreadsheet that has a column of numbers and I'm needing to know if there is away to create a function that will highlight any missing #'s in the order of sequential order?

How do I set a function to notify that there's a gap in the sequential order as listed in the example below.?

6071
6072
6077
6083
6084
6085
6086
6087
6089
6090
6092
6093
6094
6095
6096
6097
6098
6099

[#2]

Hi Leroy,

As a variant if numbers in column A you may apply conditional formatting rule

=A2<>(A1+1)

to the range starting from A2. That highlights the cells where the value is not sequential number to the value in previous cell.

[#3]

HI Sergei,

I'm not sure how I apply your recommended formula..

DO Number
6071
6072
6077
6083
6084
6085
6086
6087
6089
6090
6092
6093
6094
6095
6096
6097
6098
6099
6100
6114
6117
6120
6122
6123
6124
6125
6126
6127
6131
6134
6136
6137
6138
6141
6143
6145
6146
6147
6148
6149
6150
6152
6155
6159
6160
6161
6163
6164
6165
6168

[#4]

Hi Leroy,

Select your range except the header and very last cell, in ribbon Conditional formatting, Manage rules, New rule, select one which is using formula, add it and apply desired format for the cells. It looks like

and in attached file