Conditional formatting of top and bottom values

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

QB Unformatted Report

Conditional Formatting in Google Sheets

Greater than 10%

  • "Greater than"
  • "10%" or "0.1"
  • "Green"

Greater than 10%

Conditional Formatting in Google Sheets

Formatted QB report

Conditional Formatting in Google Sheets

Less than -10%

  • Only half of the story
  • What decreased?
  • Another rule on same page
  • Take advantage of colors
Conditional Formatting in Google Sheets

Less than -10%

Conditional Formatting in Google Sheets

Greater than less than applied

Conditional Formatting in Google Sheets

Color scale options

Conditional Formatting in Google Sheets

Color scale applied

Conditional Formatting in Google Sheets

Let's practice!

Conditional Formatting in Google Sheets

Preparing Video For Download...