Excel

[travler]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I would like to show the date of last change to a cell and have it displayed on the same worksheet. That date would be shown in a near-by cell. For example, a cost of item cell and a retail of item cell. If either cell was changed manually, then today's date would be recorded and retained until the next manual change in either cell. Have tried to use a conditional formatting solution and an "IF" formula but have not gotten it correctly.

 

[John McGhie]

This is a complex question. You need to write some AppleScript to do this.

Start your own thread so we can give you a dedicated answer with a heading a
little more descriptive than "Excel".

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I would like to show the date of last change to a cell and have it displayed
on the same worksheet. That date would be shown in a near-by cell. For
example, a cost of item cell and a retail of item cell. If either cell was
changed manually, then today's date would be recorded and retained until the
next manual change in either cell. Have tried to use a conditional formatting
solution and an "IF" formula but have not gotten it correctly.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]