Skip to content

Instantly share code, notes, and snippets.

@takumiirie
takumiirie / spreadsheet_conditional-formatting1.txt
Created January 26, 2018 08:53
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!