How to highlight the same cells in different workbooks or sheets in Excel?

Question

excel

Hello everyone, I need help with Excel spreadsheets. There are two files, new and old. Both there and there there is a Title column with names. I need to highlight the cells in the new file that are in the old file, or vice versa, highlight the cells that are not in the old file.
If it's hard to do it on different files, then at least on different sheets... I would just copy the old file to the new sheet in the new file.
The number of cells can change over time, so I would like a universal method. I will be very grateful!

Answer 1

I can offer several options for solving this problem:
1. Power Query
2. VBA code that compares and highlights the desired cells.
3. Comparison with the VLOOKUP function
4. Comparison using a pivot table
5. Conditional formatting.
The easiest and most versatile is to use Power Query