Currently Being ModeratedNov 24, 2012 5:26 AM (in response to Matt2.0)
Numbers does not have the concept of a selected cell (except to the the extent that a Use can select one or more). Numbers has function that allow a formula to know the row and column where the formula resides (shrewdly named row() and column())
Currently Being ModeratedNov 24, 2012 2:09 PM (in response to Matt2.0)
Currently Being ModeratedNov 26, 2012 9:11 AM (in response to Matt2.0)
The Numbers method, using comments as Barry showed, is probably the best method. An alternate method which is more complex would be to use an Applescript running in the background. The Applescript can scan in the background for which cell/column is currently selected and write that cell/column address into a cell in your table. A formula in your table (most likely a lookup formula) can use that address to serve up the correct help text in a diffrerent cell in the table or in another table.
Some problems with this methodare
- The script is not part of the document. It is a separate entity.
- The script must be started manually. It will not automatically start when the Numbers document is opened.
- If the Numbers document is to be used on other Macs, each would also need the script installed.