how to select no.'s in a column that differ by <1

[Danni]

aHi, could anyone tell me how to select numbers from a list/column that
differ from other numbers on the list by e.g. <1? Can I do this by inserting
formula or would this involve programming? Any help would be extremely
appreciated.

 

[Gary''s Student]

Let's say we have values in column A. First sort the column if it is not
already sorted ( or copy the column and sort elsewhere). Then select A2 and
apply Conditional Formatting Formula is:

=A2-A1<1

and copy the formatting down the column. This works because we are bringing
close values close together