Compare columns for similar values

[uncleslinky]

Hi,

I have a few columns of numbers where I want to highlight numbers that are either the same or similar. I have a formula using IF AND to find figures that are exactly the same however I can't figure out how to display the ones are that “roughly the same” or similar.

For example, is the difference between A1 and B1 less than 1000, and is the difference between B1 and C1 1000.

So,

27050 | 27903 | 27000 - would be highlighted

27000 | 18000 | 14856 - would not be highlighted


Any help would be great,
Thanks
Rich

[DonkeyOte]

Perhaps you want a conditional format Formula of:

B1: =AND(COUNT(A1:C1)=3,ABS(B1-A1)<1000,ABS(B1-C1)<1000)
set format accordingly

Can be applied across to C1 etc... though you wouldn't be able to apply the formula to A1 obviously.