Change cell color on update

C

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
 
S

Sarah Stitt

Switch on Track Changes

Tools
Track Changes
Highlight Changes
Complete the dialogue box
Click OK

Sara
 
A

Andy B

Hi

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

cmg

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