View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vera vera is offline
external usenet poster
 
Posts: 14
Default Change font color if anything changes

Hello, I'm using Excel 2003 and I have a worksheet with data in approx 1500
rows and in columns A - AN. There will be approx 8 people making updates to
this file at the same time. I then have to roll those changes back into the
"Master" document. In the past I've asked that any changes be made in
red/bold font so that I can easily find them (ususally 4-6 from each person)
Lots of times they forget, so I'm looking for a way to automatically change
the font to red/bold any time anything is changed within the worksheet. Any
suggestions? (ps most of these folks are not very Excel savy & I know it
would be even more of a problem for me to make it a "Shared Document".
Thanks for your help! :)
Vera