kobusstrydom
New member
- Joined
- Sep 30, 2011
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi Everyone
I have 2 excel spreadsheets containing mail users. The one contains all users and the other only disabled users.
Colum B contains the usernames in both sheets. But B236 in sheet1 does not contain the same data as B236 in sheet2 since sheet 2 only contains disabled users.
I would like to compare the users from sheet2 (disabled user) to sheet1 (all user) and highlight the complete row that contains the same name.
I managed to highlight duplicates with conditional formatting, but not the whole row, also some users are assigned to more than one mailbox. That user is still active but since it duplicates in the same sheet it marks as well.
Any help would be greatly appreciated.
JP
I have 2 excel spreadsheets containing mail users. The one contains all users and the other only disabled users.
Colum B contains the usernames in both sheets. But B236 in sheet1 does not contain the same data as B236 in sheet2 since sheet 2 only contains disabled users.
I would like to compare the users from sheet2 (disabled user) to sheet1 (all user) and highlight the complete row that contains the same name.
I managed to highlight duplicates with conditional formatting, but not the whole row, also some users are assigned to more than one mailbox. That user is still active but since it duplicates in the same sheet it marks as well.
Any help would be greatly appreciated.
JP