Forum Discussion
Conditional Hyperlink
To my knowledge HYPERLINK() adds link to entire cell even if it is a part of a formula or text. That's quite old question. I didn't google now, but I don't remember I've seen any workaround.
Hi, Thank you for your reply, but this video cannot solve the problem...
As the picture shows above, even if the selected text has no text, it has a hyperlink (link to nothing).
And if I put a text, for example, "A", in the [value_if_false] field, the cell will have a hyperlink link to "A". As the following pic shows:
However, from my understanding, if the Condition(U66="Yes" in this case) is False, the cell would contain the text "A" only and no hyperlink at all.
To my knowledge HYPERLINK() adds link to entire cell even if it is a part of a formula or text. That's quite old question. I didn't google now, but I don't remember I've seen any workaround.
For those who come after: my workaround was to simply link the cell to itself:
`=IF(condition, HYPERLINK(target, name), HYPERLINK("#"&CELL("address"), "no link"))`
- 4 years later, and this is still the current functionality. Unfortunately.
Thank you!
