tracking changes

  • Thread starter Thread starter angela
  • Start date Start date
A

angela

Can you track changes in Excel by highlighting the cell
instead of inserting comment box....similar to how Word
does?
 
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
--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top