Hyperlinks Excel

Hi S_C_01 

to answer your first question:

There is now standard functionality to change the color of a cell when selecting it and change back when you leave it. To achieve that, you would need VBA/macro progamming.

Regarding question 2:

There are several ways to create hyperlinks in Excel. The first one is a right-click into a cell and then choose "Link":

And then select the desired file. I assume this is the way that you created your links, but please correct me if I'm wrong. If so, as far as I know, you cannot specify a certain cell or worksheet in that file.

The second option would by the HYPERLINK function. Here you could not only specify the filename, but also the exact target sheet and cell. Example:

=HYPERLINK("[D:\Temp\Aging.xlsx]Sheet1!$A$8","Click here")

And that target address will not change even if new rows are added there.

Maybe this helps.