Microsoft Office Forums


Reply
Thread Tools Display Modes

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

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

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

--
minrufen
-----------------------------------------------------------------------
minrufeng's Profile: http://www.excelforum.com/member.php...fo&userid=2620
View this thread: http://www.excelforum.com/showthread.php?threadid=51636

 
Reply With Quote
 
 
 
 
Tom Ogilvy
Guest
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
Next

--
Regards,
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:

http://www.excelforum.com/member.php...o&userid=26208
> View this thread: http://www.excelforum.com/showthread...hreadid=516364
>



 
Reply With Quote
 
 
 
Reply

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? damaniwvk@gmail.com 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. dids72@gmail.com 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!
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)