comparing 2 columns from different files

[lezawang]

Hi
I want to compare 2 columns which are from different files and to see which value is duplicated. So one way to compare is to use Conditional formatting. The problem how can I highlight these 2 columns at the same time so I can go to Conditional formatting-->highlight duplicates values? If they are from the same sheets or file, it is easy but they are in different files. I guess conditional formatting is not going to work in case like this unless you have better idea? thank you very much.

 

[Zot]

Probably this will helps?

100. Conditional Formatting Between Two Workbooks Using Extra Columns

Conditional Formatting between two Excel workbooks, Highlight the cell color if the dates are different from the date of the second workbook, How to create a conditional format and a warning for the difference of two dates in two different Workbook, Visual warning on diversity date from two...

www.ic-ims.com