Skip to content

Instantly share code, notes, and snippets.

@iconifyit

iconifyit/Google Sheet Colorize Row by Cell Value

Last active April 15, 2019 22:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iconifyit/be1ed828733e95e6e517e9fe20f24d4d to your computer and use it in GitHub Desktop.
Save iconifyit/be1ed828733e95e6e517e9fe20f24d4d to your computer and use it in GitHub Desktop.
Download ZIP
A custom Google Sheets conditional formatting rule to colorize an entire row based on column/cell value
Raw
Google Sheet Colorize Row by Cell Value
# Select the rows to which you want the rule to apply
# Go to Format > Conditional Formatting
# Add a new formatting rule to the tool bar in the right-hand column
# Select 'Custom Formula' from the drop down
# Enter the formula below and modify the column name as needed
=(AND(NOT(INDIRECT("C" & ROW()) = ""), INDIRECT("C" & ROW()) = 0))
# Select the formatting styles youw ant to apply
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment