Change cell color on update

[CMG]

How do I change a cell's color if it has been modified? I
am sure I Use conditional formatting, but not sure how. I
have a contacts spreadsheet and I need to send it around
to other memebers of my company for them to update, when I
get it back, I need to know what has been modified. How
to do this?

Thanks!

CMG

 

[Sarah Stitt]

Switch on Track Changes

Tools
Track Changes
Highlight Changes
Complete the dialogue box
Click OK

Sara

 

[Andy B]

Hi

Have a look at Tools / Track Changes. This will highlight any changed cells
and what the changes are.

 

[cmg]

I would rather not use track changes. I can't seem to get
it right. Any way to do this with Conditional Formatting?