• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I want to compare two sheets with data and highlight the cell which is not matching

sudheer99999

New Member
I have two sheets with multiple rows as below and some columns with null values.
Now i want to compare two sheets and highlight the not matching fields
Attached the sample sheet

Example
Sheet 1. :
column
A B C D E
test 2/22/2001 abc testing
test2 333 444 cccc

sheet 2 :
A B C D E
test 2/22/2001 555 abc
test2 333 444 777
 

Attachments

  • comparing of sheets.xlsx
    10.8 KB · Views: 9
Last edited:
Check if this is what you want.
 

Attachments

  • comparing of sheets-1.xlsx
    11.8 KB · Views: 9
Back
Top