Hi, please check out my spreadsheet. I appreciate it if any one of you geniuses can help me out as I cant figure how to do this :frusty:
Download from the above link.....Sheet1 is what I am interested in having the formula do
It would look up all the divided values and find if any are within 0.2 of each other and highlight the matches different colours from other matches.
Thankyou all in advance
Download from the above link.....Sheet1 is what I am interested in having the formula do
It would look up all the divided values and find if any are within 0.2 of each other and highlight the matches different colours from other matches.
Thankyou all in advance