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

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.

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

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
--
Gary''s Student - gsnu200788


"Danni" wrote:

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.