Excel Conditional Formatting: Highlight Rules, Data Bars & Heat Maps
Highlight, top/bottom, average, duplicate and unique rules, colour-scale heat maps, data bars, formula-style rules, rule order and a KPI table with sparklines: 8 hands-on labs on one café chain's data, every rule checked by the Coach.
The first lesson is free — no account needed.
About this course
An Excel conditional formatting course on one fictional café chain's reports, for analysts, managers and anyone who wants a table to show its problems at a glance, with every rule checked by the Coach. You colour stores by % of target with greater-than, between and text-contains rules, find the line a Top 3 rule and an above-average rule actually use, count the real customers behind repeated loyalty sign-ups and colour duplicate and unique values, turn two store-by-month grids into heat maps where high is good in one and bad in the other, add data bars without letting the total spoil them, write the TRUE/FALSE formulas behind overdue-invoice and banded-row rules, resolve overlapping rules into one red, amber or green status and finish a KPI table with sparklines, a red rule for shrinking stores and a sorted bar chart. The first lab is free.
Lessons
- Highlight Cell Rules: Greater Than, Between, Text ContainsFree
- Top/Bottom Rules & Above/Below Average Pro
- Duplicate & Unique Values Pro
- Colour Scales: Two Heat Maps Pro
- Data Bars: In-Cell Bar Charts Pro
- Formula-Based Rules: Overdue Invoices & Banded Rows Pro
- Combining Rules & Rule Order: One Status, Three Colours Pro
- Capstone: KPI Table with Sparklines, Rules & a Chart Pro