Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
Comparing two worksheets and highlight unmatched Data
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Vignesh Rocks, post: 14170922, member: 118854"] Hi Team, I have did a search for what i am looking for but I haven't got what i am exactly seeking. I am sure, here the experts can help me with this. I have two worksheets named New and Old respectively and the datas would look like as shown in the attachment. In the attached workbook, New sheet needs to compare with old sheet and the columns that needs to refer are Employee Number, Name and Date of Birth. If employee # is not matching then mark the entire row in Red since Employee # can be the Key to search in old sheet (Example employee # 789). The thing here is, if any data that is not matching for a particular employee, then that cell has to be highlighted in Red and the matching data in Green. Please advice if this can be done. Your help will be really appreciated. Thanks, Vignesh [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Programming
Comparing two worksheets and highlight unmatched Data
Top