Results 1 to 10 of 10

VBA to compare and highlight differences

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2013
    Location
    Houston, TX
    MS-Off Ver
    Excel 2010
    Posts
    6

    VBA to compare and highlight differences

    Hi Everyone! I haven't been able to find what I'm looking for so maybe someone might be able to help. I have to worksheets I get from two different dbases do the output is slightly different in each. What I need is simple, (I think). Just need to get a VBA that looks from Sheet1 to Sheet2 for a doc number. If it's not on Sheet 2, simply highlight it BLUE on Sheet, AND then looks from Sheet2 to Sheet1, and if it's not on Sheet1, then highlight the entry on Sheet2 GREEN.

    I.E.

    SHEET1 SHEET2
    COL A COL A

    11111 AAAAA
    22222 BBBBB
    33333 11111
    AAAAA 44444


    Thank All!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compare two lists and highlight the differences
    By jsmo in forum Excel General
    Replies: 3
    Last Post: 08-28-2012, 10:27 PM
  2. Compare 2 Workbooks and Highlight Differences
    By LabanM in forum Excel General
    Replies: 3
    Last Post: 10-19-2010, 11:34 AM
  3. Compare two lists and highlight differences.
    By delgadotb in forum Excel General
    Replies: 1
    Last Post: 03-30-2009, 03:24 PM
  4. Compare Two Worksheets:highlight the differences
    By Jim in forum Excel General
    Replies: 1
    Last Post: 10-11-2005, 04:05 PM
  5. How do I compare 2 sets of data and highlight differences?
    By Perplexed1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-08-2005, 08:15 PM

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