View Single Post
 
Old 06-02-2014, 12:04 PM
jpb103's Avatar
jpb103 jpb103 is offline Windows 7 64bit Office 2007
Advanced Beginner
 
Join Date: May 2014
Location: Thunder Bay, Ontario
Posts: 58
jpb103 is on a distinguished road
Default Highlight cells with changed data on a worksheet with tracking changes

Greetings internet brothers and sisters,

I'm looking to write a macro that will highlight (or change the fill color) of cells that have changes (that have not yet been reviewed/accepted) on a worksheet with tracked changes enabled.

By default, tracking changes puts a tiny little comment looking triangle in the corner of cells that have been changed. Its not overly easy to see, at a glance, which cells have been modified. I'm aware that you can also export the change list to a 'History' worksheet, but my collegues don't much care for this view either. Any help would be greatly appreciated.

May bright moons guide your steps,

JP
Reply With Quote