Have spreadsheet changes automatically highlight

[Guest]

Hi,

I have a very large spreadsheet that has many columns and thousands of rows
with numerical data. I will be sending this sheet out to a few associates of
mine who will be making various changes to some of the numerical data but I
would like to receive back those changes in a highlighted color to make the
changes stand out. Is there a way to have any change typed into a cell
change either change the font or cell color?

Is there a way to do this automatically with either a function or global
setting?

Thanks in advance for your advice.

Kind regards,

 

[Guest]

Try the "Track Changes" feature:
<Tools><Track Changes><Highlight Changes>

 

[Guest]

Thanks David.

Is there a way to implement a cell fill color or font color change for all
of the changes?

Kind regards


-Tim