Forum Discussion
Excel formula question
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 |
3 Replies
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.
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 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
