Hyperlinks as Conditional Formatting?

Brass Contributor

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 rest of the url.


Example: I enter 'kittens' into cell B3 and hit enter.  Cell B3 then turns into the following hyperlink: https://www.google.com/search?q=kittens


Can this be achieved with conditional formatting (i.e., if cell is not blank, become a hyperlink)? Really trying to avoid creating a separate cell for concatenating text to create my hyperlinks...

1 Reply


No, you cannot do that with conditional formatting. It would require VBA, but assembling the URL and using the HYPERLINK function in a separate column is much easier.