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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Format cell to be a hyperlink
Excel Facts
Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Special-K99
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 8,513
- Office Version
- 2019
"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.
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.
Last edited:
Upvote
0
Similar threads
- Question
- Replies
- 1
- Views
- 133
- Question
- Replies
- 1
- Views
- 148
- Question
- Replies
- 0
- Views
- 142
- Replies
- 0
- Views
- 164
