worksheet function change text red upon edit

Can someone help me with a worksheet function to turn the current text red upon edit? I want to be able to see the changes someone makes to a worksheet.

But the question is how to turn it off once I review the changes? Could I simply change the color to automatic?

g

You could create a set of data in hidden columns that is a duplicate of the main data in its current state. Then put a conditional format on the cells that highlight the cells if the value no longer matches the value of the same cell in the hidden section.

For instance, you duplicate column A in column AA. Then use a conditional format of

=A1<>AA1

Actually, unless you want your users to get inquisitive about why the cells are lighting up and perhaps removing your CF, put the CF in the hidden section. Then you can unhide the duplicate section and see the highlighted cells THERE.

You may also want to consider utilising the Track Changes feature: http://www.ozgrid.com/Excel/track-changes.htm

Originally Posted by JBeaucaire

You could create a set of data in hidden columns that is a duplicate of the main data in its current state. Then put a conditional format on the cells that highlight the cells if the value no longer matches the value of the same cell in the hidden section.

JB, interesting concept... This would actually tell me the changes... I wasn't thinking along these lines but it give me food for thought...

Originally Posted by DonkeyOte

You may also want to consider utilising the Track Changes feature: http://www.ozgrid.com/Excel/track-changes.htm

Donkey, even tho I have 2007 for compatibility with others I'm trying to keep compatible with 2003. Does 2003 have track changes?

g

You could try something like this:

Code in ThisWorkbook

Please Login or Register  to view this content.

Code in Module1

Please Login or Register  to view this content.

Replace this string <ResultOfFindUserName> with your own UserName. You can find this by running FindOwnUserName

Yes 2003 has Track Changes feature.

Re username: when working in a Network environment it is far better to use

Please Login or Register  to view this content.

than

Please Login or Register  to view this content.

the former being your Network ID the latter being easily altered via Excel options - without knowing another users network password or without jumping on to their machine the NT login ID is pretty watertight.

Thanks guys, actually from looking into the 2003 track changes in G, I came across the concept of "Shared Workbooks". My only issue is do these files have to be on the same server to do this?

I email the file to the people who work on the file and the email it back. Will shared work in that method?

g

I believe you've asked that question in another thread which is probably a good way to do it... if this particular question has been answered please mark this thread as solved and continue with the other (see FAQ / How To? if unsure)

Thanks

Yes, I posted it as separate issue. I was trying to update this topic with my current status since I'm current working on this project.

g