Match values of A column with B column if not match then highlight it through VBA code

Not quite clear how you define the second same pair.

Please Login or Register  to view this content.

your code not working properly see in to attached file please see cell A2 and cell B4 perfectly matching but even so code highlighted that values same thing happen about cell A8 and cell B6 , there is so many these types of mistake happen due to this code so please do amendement in that code

and do not worry about second pair forget about second same pair just do remaining thing it means forget about green color,

but i am surprised for that your code working perfectly on small data but not working on big data why this happen i dont know

try

Please Login or Register  to view this content.

thanks now your code slightly working properly but if you can do please do some amendment look in to attached file
see cell A145 and B143 value of that cells near by same but why code highlighted it by different color it should be in yellow color or if possible do not highlight these types values which difference in only in decimal point for example cell A145 and cell B143 difference of that values is only 0.045 so if possible do not highlight these values which difference is less than one, now your code near by work properly

also one more thing i want that suppose 26558 this value appear two time in column A and appear one time in B column
so highlight that extra one value which is in column A because it is appear one time extra in column A so highlight that
extra value