1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. 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


  3. 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

Discussion in 'Ask an Excel Question' started by sudheer99999, May 16, 2018.

  1. sudheer99999

    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

    Sheet 1. :
    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

    Attached Files:

    Last edited: May 16, 2018
  2. Haz

    Haz Active Member

    Check if this is what you want.

    Attached Files:

Share This Page