comparing 2 workbooks

I have too workbooks that I need to compare. I would like to find the duplicates from each and put them in another workbook.

here are the params:

in col c -workbook old are a list of training tools used in one area
in col d -workbook new are a list of training tools used in another area.

in the new workbook I would like to pull the data into it and the use conditional formatting to highlight the duplicates.

Thanks in advance