How To Apply Conditional Formatting To A Row In Google Sheets

Color the entire row if a box is checked

The aim of this playbook🏁 is to show whole-row formatting based on a value. Remember The Checklist Manifesto, and read the argument Rediscover the magic of spreadsheets I do need strong visuals to see what I am working on.

  1. Select area to which you want to apply this (not everything)
  2. Open Conditional Formatting → Select Custom Formula
  3. As a formula enter =$<col><num>=<value>, for example checking the box makes the row colorful.
Apply to range: A3:F999
Format cells if... Custom formula is
=$F3=TRUE

Note that rows must match in range and formula (3 in the example above)

--

--

Infrastructure Support Engineer/Technical Writer (snowplow.io) with a passion for Python/writing documentation. More about me: https://pavol.kutaj.com

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Pavol Kutaj

Infrastructure Support Engineer/Technical Writer (snowplow.io) with a passion for Python/writing documentation. More about me: https://pavol.kutaj.com