highlight unique values between two workbooks

Hi,

i have code that will highlight rows in workbook 1 if the values in column A of workbook 1 match the values in column A of workbook 2. Now i need to do the opposite and highlight any rows that have a unique value in column A of workbook 1 that is not found in column A of workbook 2.I need to do this using VBA. Below is the code i have which works for highlighting matching values. any help is greatly appreciated.

Please Login or Register  to view this content.

Sorry i wasn't clear. The code i posted works for what i need it to do. In that code i want to highlight column I if the A = A and I does not = I. What i don't know how to do is to highlight the entire row in workbook 1 if the value in column A in workbook 1 does not match any of the values in column A of workbook 2. so something like

Please Login or Register  to view this content.

Except that this doesn't work. It highlights every single row since there is obviously going to be a value that doesn't match since it is searching the entire column.

From searching around it seems that i will need to create a custom function but i don't know how to do that properly.

Hope this clarifies.

Also, you mentioned that i am not using the best method. I am new to VBA so if you don't mind showing me a better method i would really appreciate it.

Awesome! used the Match function and worked like a charm!

Thank you!