2

I want to easily see what text in Column A has a link in it by looking at Column B.

1

Apply to range B:B

custom formula =isurl(A1)

If you want it to detect custom hyperlinks then you need to do something like this

=or(isurl(A1),iferror(search("hyperlink",formulatext(A1))))
  • That worked! Thank you so much! – Lizzie C Nov 26 at 21:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.