Chapter 5: Conditional formatting basics
Exercise 23: Show sizes with data bars
Task
Add data bars so the sales sizes are clear at a glance.
Moves 0 (target 1)5 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Item | Sales | |
| 2 | Notebook | 4200 | |
| 3 | Pen | 1800 | |
| 4 | File | 6100 | |
| 5 | Sticky notes | 900 | |
| 6 | Glue | 2600 | |
| 7 | |||
| 8 |
Add data bars so the sales sizes are clear at a glance.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B6
- Home > Conditional Formatting > Data Bars (Alt → H → L → D)
- Choose a bar color
Key takeaway
The bar length shows the size without reading the numbers.
See conditional formatting for details.