Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-02-2014, 12:04 PM
jpb103's Avatar
jpb103 jpb103 is offline Highlight cells with changed data on a worksheet with tracking changes Windows 7 64bit Highlight cells with changed data on a worksheet with tracking changes Office 2007
Advanced Beginner
Highlight cells with changed data on a worksheet with tracking changes
 
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
 

Tags
highlight changes, tracking changes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Highlight cells with changed data on a worksheet with tracking changes Using macros to highlight worksheet words referenced in external list/doc. Daniel_NYC Word VBA 1 04-21-2014 03:35 PM
Can you copy & paste cells across worksheets and preserve reference to worksheet? New Daddy Excel 2 11-27-2013 07:19 AM
Highlight cells with changed data on a worksheet with tracking changes Cells no longer wrap text when changed in nested table erik2000 Word Tables 1 03-29-2013 03:27 PM
Highlight cells with changed data on a worksheet with tracking changes "Auto-populating" data-worksheet to worksheet. meggenm Excel 4 02-04-2012 02:04 AM
Highlight cells with changed data on a worksheet with tracking changes Cells from other worksheets apear on current worksheet Equilar Excel 3 05-03-2010 01:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:01 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft