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.
Kindly check the video link below for possible answer to your question
https://m.youtube.com/watch?v=-WezTrJZ7Dc
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"))`
