Forum Discussion
Hyperlinks as Conditional Formatting?
I would like to turn a cell into a hyperlink when text is entered into that same cell. The text entered into the cell would be the very last part of the hyperlink, which is concatenated with the res...
I have found that you can accomplish this by setting the value_if_false portion to hyperlink to a cell on your sheet.
For example :
=IF(H38<>"",HYPERLINK("google.com/search?q="&H38,H38),HYPERLINK(H38,""))
If H38 = "kittens", then your cell would show the word "kittens" and would be a hyperlink (to a google search for kittens, in this example).
If H38 is blank, then your cell would be blank and would not actually perform any action when clicked.