A primer on conditional formatting

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

When to use conditional formatting

• Small or medium size data
• Changing data
  • Formatting remains when the underlying data changes

Parts of conditional formatting

• "Single color" / "Color Scale"

Parts of conditional formatting

• "Single color" / "Color Scale"
• "Range"

Parts of conditional formatting

• "Single color" / "Color Scale"
• "Range"
• "Condition" ("Format cells if...")

Parts of conditional formatting

• "Single color" / "Color Scale"
• "Range"
• "Condition" ("Format cells if...")

Parts of conditional formatting

• "Single color" / "Color Scale"
• "Range"
• "Condition" ("Format cells if...")
• "Style"

Let's give it a try!

Conditional Formatting in Google Sheets