Hello all!
Busy night trying to find a solution, so let me explain what I am facing. I have a range of cells, each cell contains a number. I would like to set a conditional format that highlights two numbers the same color if they are within a given numbers of digits of each other.
For example say I have the following numbers in a range:
136 119 102 85 68 51 34 17 0 42 59 76 93 110 127 144 161 178 195
220 203 186 169 152 135 118 101 84 126 143 160 177 194 211 228 245 262 279
304 287 270 253 236 219 202 185 168 210 227 244 261 278 295 312 329 346 363
I wanted to test to find out if there was any numbers in that range that were 8 or less digits of each other.
What type of VBA or looped function could I use to highlight the two cells that contained numbers that were 8 or less apart red?
Thanks for any help in advance.
Bookmarks