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 or...
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