Editing a macro for custom comparing

[Zaeguzah]

Hello people. I got this macro that compares two workbooks and then highlights the changes in each file. What I need is to edit the script so that it will compare the column "C" from the opened workbook to the same column on the selected book. Everything that exists in the old list but not in the new needs to be highlighted with a color. And everything that exists in the new and not in the old requires also a color. Folow me so far?
Basically, I need it first to search for "obsolete" products and then for new ones and put each of them in a color in their original workbook. Below I upload the two exaples and the code I used so far.
Any help will be extremely appreciated.

Please Login or Register  to view this content.

[Zaeguzah]

Please, anyone?

[pike]

dude at a glance
Play around with the specfic column in the usedrange
have to go,footie grand final weekend , but if you still can get it I'ii work on the code

Please Login or Register  to view this content.

Go the Saints

[Zaeguzah]

It works but the same as the original. I only need it to highlight colum 3. Then when it searches for entries it needs to search an entry from one book to the entire colum in the second book, something similar to vlookup. Products are never located at the same location but they are there and this gives false positives.
Thanks so far.

[pike]

try this untested - apologies I your reply

Please Login or Register  to view this content.

there maybe a better way

[Zaeguzah]

Sorry for the log delay. Still nothing, works but not good for what I need. Still, you mentioned that it may be done in a better way, what did you mean by that?