Hello.

I have three columns in two separate workbooks. I wish to find out which cells are different in workbook B given workbook A.

I'm really not sure how to explain it, so I will provide an example

Workbook A
110 6/20 73
110 7/01 93
110 8/04 82
140 6/15 24
140 7/10 11

Workbook B
110 6/20 99
110 7/03 93
110 7/22 11
110 8/04 82
140 6/15 24

First, I look at the first row from Workbook B. The first column shows 110, so I want to first make sure 110 exists in Workbook A. If it does, then I look at the second column, which is 6/20. I look over at workbook A, and make sure 6/20 exists in the second column where the first column is also 110. (if 6/20 exists, but 110 is NOT in column A, that does NOT count). Then I check out the third column, it shows 99, and try to find 99 in workbook A where column A = 110, and column B = 6/20.
If workbook B shows something different, then I want to highlight that cell.

So in this example: 99, 7/03, 7/22, 11 from Workbook B will be highlighted.

Anyone know of any built-in Excel functions or any VBA way to do this?

Thanks in advance!
(if my question is unclear, please let me know and I will try to clear it up)