Get startedGet started for free

Adding a splash of color to status columns

Your team lead wants to see at a glance how the tracker is doing. Use Copilot to add two conditional formatting rules to the Status column: highlight "Complete" in green, then "Overdue" in amber. With both marked, the balance between finished and late work is obvious without counting. Verify the column, condition, and color for each rule.

This exercise is part of the course

Microsoft Copilot in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise