Skip to content

Instantly share code, notes, and snippets.

@cdparra

cdparra/Google spreadsheet custom formula for formatting example

Created August 24, 2017 13:47
Show Gist options
  • Save cdparra/c0efd38d222dd26ba875bffa4a5eaeba to your computer and use it in GitHub Desktop.
Save cdparra/c0efd38d222dd26ba875bffa4a5eaeba to your computer and use it in GitHub Desktop.
Download ZIP
Snippet on how to use custom formula INDIRECT in spreadsheets for conditional formatting
Raw
Google spreadsheet custom formula for formatting example
=INDIRECT("SheetName!"&ADDRESS(row();column()))="VALUE"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment