User Profile
kortnie
Copper Contributor
Joined 7 months ago
User Widgets
Recent Discussions
Re: Hyperlinks as Conditional Formatting?
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.1.1KViews0likes0Comments
Recent Blog Articles
No content to show