compare 2 columns of data in different worksheets
Posted on 2013-12-05
I have a list of numbers in column B in a worksheet called 2012 and I need to compare them to another similar column B of numbers in another worksheet called 2013. I need to be able to highlight (change color of cell background) if exact number exists in original Column B. The numbers are 6 figure numbers each time.