0
0
Google Sheetsspreadsheet~8 mins

Conditional formatting basics in Google Sheets - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Conditional formatting basics
Goal

Highlight sales values above 500 to quickly see strong sales in the data.

Sample Data
ProductRegionSales
ApplesNorth450
BananasSouth600
CherriesEast700
DatesWest300
ElderberriesNorth550
Dashboard Components
  • Sales Table: Shows product, region, and sales data.
  • Conditional Formatting Rule: Applies to Sales column (C2:C6).
    Rule: Format cells if "Cell is greater than" 500.
    Format: Fill color light green.
Dashboard Layout
+-----------------------------+
|        Sales Table           |
|  (with conditional format)  |
+-----------------------------+
Interactivity

The conditional formatting updates automatically when sales values change. If a sales number becomes greater than 500, the cell background turns light green. If it falls to 500 or below, the formatting is removed.

Self Check

Change the sales value for "Dates" from 300 to 520. Which cells change color?

  • Answer: The "Dates" sales cell (C5) will turn light green because 520 > 500.
Key Result
A sales table with conditional formatting highlighting sales above 500 in green.