Change font color if anything changes

[Vera]

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

 

[Gord Dibben]

Would be easy enough using some type of event code.

Would need to have more details.

You state "8 people making changes at the same time"

How is this done if the workbook is not shared?

Do they each have a copy of the same workbook under a unique name which they
send to you?

What type of changes would you be looking for?

Simple manual changes to cells values?

Any formulas involved that require calculation?

Any cut/copy/pasting?


Gord Dibben MS Excel MVP