Have spreadsheet changes automatically highlight
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, |
Have spreadsheet changes automatically highlight
Try the "Track Changes" featu
<Tools<Track Changes<Highlight Changes -- Regards, Dave "Tim Miser" wrote: 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, |
Have spreadsheet changes automatically highlight
Thanks David.
Is there a way to implement a cell fill color or font color change for all of the changes? Kind regards -Tim "David Billigmeier" wrote: Try the "Track Changes" featu <Tools<Track Changes<Highlight Changes -- Regards, Dave "Tim Miser" wrote: 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, |
All times are GMT +1. The time now is 09:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com