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
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
Last edited: