Results 1 to 6 of 6

Compare two columns in two different spreadsheets and Highlight difference

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2011
    Location
    germany
    MS-Off Ver
    Excel 2003
    Posts
    35

    Compare two columns in two different spreadsheets and Highlight difference

    Hi

    My request is

    1) To compare one column A in sheet1 with column A in sheet 2 , once the value of both are equal, then compare Column B of sheet1 and column B of Sheet2, if they are same , do nothing but if they are different , Highlight it with a colour.

    2) If the value in column A of sheet 1 is not present in the column A of sheet 2 , then show "New Entry"

    Kindly help me with a macro or some formula which can give these results. Spreadsheet attached.

    Thanks a lot for your help

    Regards
    Shilloh
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1