MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Highlighting


Posted by Adam Warner on April 25, 2001 7:36 AM

I need to send a large spreadsheet to a customer who is going to make some changes to this sheet. I need the easiest way to identify the changes that this individual has made. I am thinking of a macro that would highlight these changes. Can anyone tell me how i can accomplish this. Obviously i don't want this highlighting to occur when i make changes...just when the client has made some.

Thanks


Posted by IML on April 25, 2001 8:07 AM

Have a look at the built in functionality under
Tools - Track Changes - Highlight Changes