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 but weren't in sheet 1. The data in the sheets would look like this:
sheet1
| Smith, Joe | email address removed for privacy reasons |
| Jones, Dave | email address removed for privacy reasons |
| Hall, Daryl | email address removed for privacy reasons |
| Oates, John | email address removed for privacy reasons |
| Nelson, Roger | email address removed for privacy reasons |
Sheet 2
| Smith, Joe | email address removed for privacy reasons |
| Jones, Dave | email address removed for privacy reasons |
| Stein, Chris | email address removed for privacy reasons |
| Hall, Daryl | email address removed for privacy reasons |
| Oates, John | email address removed for privacy reasons |
| Nelson, Roger | email address removed for privacy reasons |
In this situation, I only want it to highlight or call out Chris Stein as the new employee. Is there a way to accomplish this?
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!
