Compare two worksheets and highlight the one sheet’s difference from the other one

Discussion in 'Excel Programming' started by minrufeng, Feb 24, 2006.

  1. minrufeng

    minrufeng Guest

    minrufeng, Feb 24, 2006
    #1
    1. Advertisements

  2. minrufeng

    Tom Ogilvy Guest

    Re: Compare two worksheets and highlight the one sheet's difference from the other one

    for each cell in Activesheet.usedRange
    if cell.Value <> Worksheets("Sheet2").Range(cell.Address) then
    cell.Interior.ColorIndex = 3
    end if
    Next

    --
    Regards,
    Tom Ogilvy

    "minrufeng" <> wrote
    in message news:...
    >
    > Does anyone know how to do this? Thank you for your great help!
    >
    >
    > --
    > minrufeng
    > ------------------------------------------------------------------------
    > minrufeng's Profile:

    http://www.excelforum.com/member.php?action=getinfo&userid=26208
    > View this thread: http://www.excelforum.com/showthread.php?threadid=516364
    >
     
    Tom Ogilvy, Feb 24, 2006
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Jay Jones
    Replies:
    1
    Views:
    108
    Peter Rooney
    Mar 20, 2006
  2. TEAM

    Compare Two Worksheets and Highlight Changes

    TEAM, May 8, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    203
    Raymond Langsford
    May 10, 2006
  3. Odin
    Replies:
    1
    Views:
    106
    Stefi
    Jun 28, 2006
  4. Replies:
    1
    Views:
    184
    Tom Ogilvy
    Jun 22, 2007
  5. Lisab
    Replies:
    10
    Views:
    241
    Bill Renaud
    Sep 12, 2007
  6. Replies:
    3
    Views:
    173
    Tom Ogilvy
    Sep 19, 2007
  7. mrcreid
    Replies:
    7
    Views:
    141
    mrcreid
    Aug 10, 2010
  8. Joshua Houck
    Replies:
    19
    Views:
    393
    Vacuum Sealed
    Aug 19, 2011
Loading...