Font and text styling in Google Sheets - Dashboard Guide

Dashboard Mode - Font and text styling

Dashboard Goal

Show how to use font and text styling in Google Sheets to highlight important sales data and improve readability.

Sample Data

Product	Region	Sales	Status
Apples	East	150	Good
Bananas	West	90	Average
Cherries	East	200	Excellent
Dates	South	50	Poor
Elderberries	West	120	Good

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUBTOTAL(109,C2:C6)
  Shows total sales across all products.
• Styled Sales Table
  Uses conditional formatting:
  • Sales >= 150: Bold and green font
  • Sales < 100: Italic and red font
  • Status = 'Excellent': Blue font and underline
  Helps quickly see high and low sales and top status.
• Average Sales
  Formula: =SUBTOTAL(101,C2:C6)
  Displayed with bold font to stand out.

Dashboard Layout

+----------------------+----------------------+
|   Total Sales (KPI)  |   Average Sales (KPI) |
+----------------------+----------------------+
|                                              |
|            Styled Sales Table                 |
|                                              |
+----------------------------------------------+

Interactivity

Apply a filter on the Region column to show sales only for selected regions. When filtered:

• Total Sales and Average Sales update to reflect filtered data.
• Styled Sales Table shows only rows matching the filter with the same font styling rules.

Self Check

If you add a filter for Region = East, which components update?

• Total Sales and Average Sales show sums and averages only for East region (Apples and Cherries).
• Styled Sales Table shows only Apples and Cherries rows with correct font styling.

Key Result

Dashboard demonstrating font and text styling in Google Sheets to highlight sales data with interactive region filtering.