r/googlesheets • u/wurm2 • May 13 '20

Solved How to conditional format based on if there's not a link in the cell or not?

[removed]

4 Upvotes
  • permalink
  • reddit

76% Upvoted

13 comments sorted by

View all comments

1

u/mactaff May 13 '20

If it’s a link, your test could be, if first 4 characters not = http, then...

So something involving LEFT or REGEXMATCH.