Microsoft Office Forums

Thread Tools Display Modes

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

Posts: n/a
      02-24-2006, 09:44 PM

Does anyone know how to do this? Thank you for your great help

minrufeng's Profile:
View this thread:

Reply With Quote
Tom Ogilvy
Posts: n/a
      02-24-2006, 10:19 PM
for each cell in Activesheet.usedRange
if cell.Value <> Worksheets("Sheet2").Range(cell.Address) then
cell.Interior.ColorIndex = 3
end if

Tom Ogilvy

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

Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I PREVENT text in emails from being different sizes and some bolded? Outlook General 2 05-19-2013 06:58 PM
CountIf from multiple sheets in another workbook JoshBrunz Excel Misc 4 05-15-2013 11:13 PM
Separting negative numbers from letters in cells patatwork Excel Misc 1 05-15-2013 09:06 PM
Compare two worksheets in the same workbook and highlight difference mrcreid Excel Programming 7 08-10-2010 07:31 PM
Compare Rows on different Worksheets and Output Difference's to other Worksheets. Excel Programming 3 09-19-2007 03:48 PM

All times are GMT. The time now is 07:13 AM.
Microsoft Office Forums is not affiliated with Microsoft Corporation.

Welcome to the Microsoft Office Forums

Latest Threads
Remote help?
newman200 (04-13-2014, 12:54 PM)

Access command button help needed
MikeyL (04-06-2014, 07:01 PM)

Page number problem
satrah (04-06-2014, 10:48 AM)

3 line boarder
satrah (04-06-2014, 01:30 AM)

send from OneNote 2013 to PowerPoint 2013?
havping (04-01-2014, 09:50 PM)