Icon sets in Excel - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants a quick visual summary of monthly sales performance for each product category using icon sets.

📊 Data: You have monthly sales data for different product categories including sales amounts and targets.

🎯 Deliverable: Create a table with sales data and apply icon sets to the sales column to visually show performance compared to targets.

Sample Data

Category	Month	Sales	Target
Electronics	January	12000	10000
Electronics	February	9000	10000
Clothing	January	7000	8000
Clothing	February	8500	8000
Home Goods	January	6000	7000
Home Goods	February	7500	7000
Sports	January	4000	5000
Sports	February	5500	5000

1

Step 1: Enter the sample data into an Excel sheet with columns: Category, Month, Sales, Target.

No formula needed for this step.

Expected Result

Data is organized in a clear table format.

2

Step 2: Select the Sales column cells (C2:C9) where you want to apply icon sets.

No formula needed, just select cells C2 to C9.

Expected Result

Sales data cells are selected.

3

Step 3: Go to Home tab > Conditional Formatting > Icon Sets > Choose the 3 Arrows icon set.

Apply 3 Arrows icon set to selected Sales cells.

Expected Result

Each sales value shows a green, yellow, or red arrow based on its relative value.

4

Step 4: Adjust the icon set rules to compare Sales against Target values for better accuracy.

Go to Conditional Formatting > Manage Rules > Edit Rule. For the first threshold (yellow arrow minimum): Type 'Formula', Value '=D2*0.9'. For the second threshold (green arrow minimum): Type 'Formula', Value '=D2'.

Expected Result

Icons reflect if sales meet or exceed targets (green), are close (yellow >=90% of target), or below (red).

5

Step 5: Review the table to see which categories and months met or missed sales targets visually.

No formula, just observe the icon set results.

Expected Result

Visual summary with arrows shows performance at a glance.

Final Result

Category   Month     Sales    Target   Performance
---------------------------------------------------
Electronics January   12000    10000    ↑ (green)
Electronics February  9000     10000    → (yellow)
Clothing   January    7000     8000     ↓ (red)
Clothing   February   8500     8000     ↑ (green)
Home Goods January    6000     7000     ↓ (red)
Home Goods February   7500     7000     ↑ (green)
Sports     January    4000     5000     ↓ (red)
Sports     February   5500     5000     ↑ (green)

✓Electronics and Clothing had mixed sales performance across months.

✓February sales generally improved compared to January.

✓Icon sets quickly highlight which sales met or missed targets.

Bonus Challenge

Create a new column that calculates the percentage of sales to target and apply a 5-icon set to show finer performance levels.

Show Hint

Use formula =C2/D2 to calculate percentage, then apply icon sets with 5 levels for detailed visual.