Hello all,

This is my first post to these forums after being a long time lurker.

I have a long list of large numbers in column Q. The closer the numbers are to each other, the more related their respective rows are to each other. I am trying to figure out a way of highlighting the cells that are within a certain number range of each other. I am attempting to use conditional formatting to do this, and here is one of the formulas I'm using.

=AND($Q1-$Q:$Q<305.3,$Q1-$Q:$Q>-305.3)
The value of 305.3 is the difference threshold I'm looking for between any two numbers in the column.

I know what you're thinking. Just sort the column from low to high and compare one number to the next number in the column. I would do that, but this formula is just step one in a more complicated formula I'm going to attempt to create in the future, so I need the formula to work on an unsorted column.

Whenever I run this formula excel locks up and force closes. Is there a better way of doing this? Either with a smarter formula or VBA code or something similar? Any help would be appreciated, and thank you.