Skip to content

Instantly share code, notes, and snippets.

@takumiirie
Created January 26, 2018 08:53
Show Gist options
  • Save takumiirie/7aa349c6948b79c6f44534013f4de283 to your computer and use it in GitHub Desktop.
Save takumiirie/7aa349c6948b79c6f44534013f4de283 to your computer and use it in GitHub Desktop.
Google Spreadsheet - Regex with Conditional Formatting
# set "Apply to range" to whereever you want to apply setting.
# set "Format cells if..." to "Custom formula is" and paste following code
# Following Forumula will detect if it's match with regex or not.
=REGEXMATCH(INDIRECT("R[0]C[0]", false),"<PUT YOUR REGEX HERE>") = true
# set your "formatting style"
That's it!
@agrrh
Copy link

agrrh commented Dec 7, 2020

Thanks, you saved my day 👍

@samanthambarnes
Copy link

So helpful! I'll be using this a lot.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment