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

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

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    2
    Views:
    68
    Ingolf
    Jun 22, 2007
  2. TEAM

    Compare Two Worksheets and Highlight Changes

    TEAM, May 8, 2006, in forum: Excel Programming
    Replies:
    2
    Views:
    85
    Raymond Langsford
    May 10, 2006
  3. Replies:
    1
    Views:
    79
    Tom Ogilvy
    Jun 22, 2007
  4. Replies:
    3
    Views:
    50
    Tom Ogilvy
    Sep 19, 2007
  5. mrcreid
    Replies:
    7
    Views:
    55
    mrcreid
    Aug 10, 2010
Loading...

Share This Page