Format cell to be a hyperlink

[Hydestone]

I have a cell which is referencing a cell in another worksheet, which contains an email address. The source cell formats properly as a hyperlink, but the destination (?) cell does not format as a hyperlink. Is it poissible to have the destination cell be formatted as a hyperlink?

 

[Special-K99]

"which contains an email address"

is an email address or contains an email address?

No cell references mentioned at all, so over to you to modify the solution to fit your spreadsheet.

If is an email address then

in A1
=HYPERLINK(B1)

where B1 is the email address.

 

[Hydestone]

Sorry for the vague details!

I put the =hyperlink into the cell and it works nicely!