Font styling (bold, italic, color) in Excel - Dashboard Guide

Dashboard Mode - Font styling (bold, italic, color)

Dashboard Goal

This dashboard helps you see how to change the look of text in Excel cells using bold, italic, and color styles. It answers: How can you make important numbers stand out by changing their font style?

Sample Data

Item	Sales	Status
Apples	150	Good
Bananas	90	Average
Cherries	200	Excellent
Dates	50	Poor
Elderberries	120	Good

Dashboard Components

• KPI Card 1: Total Sales
  Formula: =SUM(B2:B6)
  Result: 610
  Shows the total sales for all items.
• KPI Card 2: Bold High Sales
  Cells B3 (200) and B2 (150) are formatted bold because sales are above 140.
• KPI Card 3: Italic Average Sales
  Cell B4 (90) and B6 (120) are formatted italic because sales are between 80 and 140.
• KPI Card 4: Colored Status
  Cells in column C have font colors:
  • Green for "Excellent"
  • Blue for "Good"
  • Orange for "Average"
  • Red for "Poor"

Dashboard Layout

+----------------------+----------------------+----------------------+
|   Total Sales (610)   |  Bold High Sales     | Italic Average Sales |
|                      |  (B3=200, B2=150)   |  (B4=90, B6=120)     |
+----------------------+----------------------+----------------------+
|                      Colored Status Font Colors                   |
|               (Green, Blue, Orange, Red in column C)              |
+------------------------------------------------------------------+

Interactivity

You can change the sales numbers or status text in the table. When you do:

• The Total Sales updates automatically.
• Cells with sales above 140 become bold.
• Cells with sales between 80 and 140 become italic.
• Status text color changes based on the status word.

This helps you quickly see which items are doing well or need attention.

Self Check

If you change the sales for "Dates" from 50 to 160, which components update?

• Total Sales will increase.
• Cell B5 (Dates) will become bold because 160 > 140.
• Cell B5 will no longer be italic.
• Status color stays the same unless you change the status text.

Key Result

Shows how to use bold, italic, and font colors in Excel cells to highlight sales data.