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