Course
Conditional formatting exercises
Five exercises, from a simple Greater Than rule to an overdue-invoice tracker. Each sheet is checked instantly, with a hint and the explanation if you get stuck.
Read the conditional formatting guide
Exercise 1 of 5
Highlight the best sales
Highlight the sales above 5000 in B2:B9 with Green Fill with Dark Green Text. Select the range, click Conditional Formatting and use Greater Than.
| Rep | Sales ($) |
| Olivia Reed | 4,200 |
| James Carter | 6,100 |
| Sofia Patel | 3,800 |
| Liam Brooks | 7,450 |
| Emma Hughes | 5,000 |
| Noah Bennett | 2,900 |
| Ava Collins | 5,600 |
| Ethan Ward | 4,999 |