Compare two columns in two different spreadsheets and Highlight difference

Hi Fotis

Thanks for your quick response. It works fine when the order of column A doesnt change in both the sheets. But i have a slightly different requirement, if the order in Column A is different in both the sheets, im unable to get the results.

Ive attached the table. Should we use vlookup?

Thanks in advance