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:
    103
    Peter Rooney
    Mar 20, 2006
  2. TEAM

    Compare Two Worksheets and Highlight Changes

    TEAM, May 8, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    195
    Raymond Langsford
    May 10, 2006
  3. Odin
    Replies:
    1
    Views:
    100
    Stefi
    Jun 28, 2006
  4. Replies:
    1
    Views:
    171
    Tom Ogilvy
    Jun 22, 2007
  5. Lisab
    Replies:
    10
    Views:
    235
    Bill Renaud
    Sep 12, 2007
  6. Replies:
    3
    Views:
    162
    Tom Ogilvy
    Sep 19, 2007
  7. mrcreid
    Replies:
    7
    Views:
    133
    mrcreid
    Aug 10, 2010
  8. Joshua Houck
    Replies:
    19
    Views:
    380
    Vacuum Sealed
    Aug 19, 2011
Loading...