Forum Discussion
Compare Data in two sheets
Hello, I receive a list on a weekly basis of all employees at my company. I'd like to compare one sheet to the other to determine new employees and only show the new employees who are in sheet 2 ...
You can try conditional formatting. Easiest way would be to enter the data into one sheet (copy and paste) and then select the data as shown in the screenshot. Then ranges in columns B and E are selected with the mouse.
You can apply conditional formatting with this path:
Conditional formatting -> Highlight cells rules -> Duplicate Values
Now only the new employee isn't highlighted in red.
OliverScheurich Thanks for this! It worked perfectly!
