Conditional formatting basics in Excel - Dashboard Guide

Dashboard Mode - Conditional formatting basics

Dashboard Goal

Highlight sales values above $500 to quickly see strong sales performance.

Sample Data

Product	Sales ($)
Apples	450
Bananas	520
Cherries	610
Dates	300
Elderberries	700
Figs	480
Grapes	530

Dashboard Components

• KPI Card: Total Sales
  Formula: =SUM(B2:B8)
  Result: 3590
• Sales Table: Shows products and sales with conditional formatting applied.
  Conditional Formatting Rule: Format cells in B2:B8 with fill color light green if value > 500.

Dashboard Layout

+----------------------+------------------+
|      Total Sales      |  Sales Table     |
|       (KPI)           |  (with colors)   |
+----------------------+------------------+

Interactivity

No filters or slicers in this simple dashboard. The conditional formatting updates automatically if sales values change.

Self Check

If you change the sales value for "Dates" from 300 to 550, which cells get highlighted?

Answer: The cell for "Dates" sales will turn light green because 550 > 500.

Key Result

Dashboard shows total sales and highlights sales above $500 in the sales table.