Match values of A column with values of B column in the attached file
you can see cell A1 value perfectly match with cell
B5 value so i did not highlight that value , cell A2 value also matching with cell B4 value, but you can see
value of A6 and value of B8 difference of both values is less than two so i highlight that values in yellow
color also cell A13 and cell B14 values difference is less than two so i also highlight that values in yellow
color , but cell A10 and cell B9 between that cell values difference is greater than two but less than ten
so i highlight that values in red color, you can see in cell A13 and cell B14 that is first pair i highlight
in yellow color and second same pair because it is appear second time in A column and B column so that
second pair i highlight in green color so remember always highlight second pair in green color, then you
can see value of A19 no match found in B column so i highlight it in blue color also value of cell B18
no match found in A column so i highlight it in blue color, so how do that above whole process through
VBA code, thanks
Bookmarks