tracking changes

A

angela

Can you track changes in Excel by highlighting the cell
instead of inserting comment box....similar to how Word
does?
 
D

David McRitchie

Hi Angela,
See
Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm

You might want to do something yourself with an event macro instead
because highlight changes is simply a nuisance, as far as I'm concerned.
It is for something like a finished project where any little change is recorded.
Then you turn it off and start all over again.

Some sample Event macros as an alternative
Color a Cell When a Change is Made (#chg010)
http://www.mvps.org/dmcritchie/excel/event.htm#chg010
--
 
Top