Hello clever Excel people,
I have tried various different formulas with no success. Basically I have a
row of values, lets say: 10,45,12,28,30. I need formula that I can enter into
conditional formatting so that if any of the values are less than 3 away from
any of the other values (eg: 10 and 12 are too close, as are 28 and 30), it
will turn a different colour to highlight the error. Please help, I have
exhausted all the Excel geeks at work including the IT department.
Thank you :-)