Not sure if this is a hyperlink

[cherrry11]

I have a cell A1 on worksheet 1 in workbook 1, and I would like it to show the amount from cell A1 on worksheet 2 in workbook 1.
I would like the amount from the cell to show as well as have it then link me to the second worksheet if I click on it.
I can do each function seperately, is there a way to have one cell do both functions (have the amount from a cell, then link to that cell)?
I hope this isn't to confusing
Thank you in advance for your help.

 

[VoG]

In Sheet2!A1 enter =Sheet1!A1

Click in Sheet2!A1 Insert > Hyperlink, Click Place in this Document, Enter A1 as the cell reference and click Sheet1, click OK.

 

[cherrry11]

Thank you

That worked thanks for the help and quick response!
Is there anyway to have the hyperlink font be a different color? I know that it is blue when not looked at and purple once opened. I need it to be red is this possible?

 

[Richard Schollar]

You should be able to change the colour by changing the font colour (ie Format>Cells and Font tab).

Richard