Hi All,

I have yet another big project on hand. This is the requirement. I have two worksheets (Sheet1) and (Sheet2). I have some data on sheet1 and some on sheet 2. I will need to compare column A with Column A, if they match Shade them, and then compare Column B with Column B if they match shade them and then Column C with Column C. Now if all the three columns match, for which some will and some won?t. If all the three columns match, then I will to Copy the entire record to a new workbook/worksheet.

Looking forward to your help, thanks in advance.

Regards,
Richard.