Excellency AcademyOpen the appAdministration and Executive AssistantTier 245 minintermediate
Conditional Formatting with Formula Rules
Highlight cells based on their own values or other cells.
What you will learn
- Apply built-in conditional formats (color scales, data bars)
- Write formula-based rules
- Understand relative vs. absolute references in rules
- Layer multiple rules and understand precedence
Excel skills
Conditional Formatting, formula rules, color scales, data bars · Visual Indicators
The task
Sixteen cost centres, budget against actual. I want anything over budget highlighted automatically, so it stays highlighted as the actual figures get updated through the month rather than needing someone to eyeball it and colour cells in by hand every time.
You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.