KPI Cards with Green/Red Rules
This lesson is part of the course
In this lesson
You build two KPI cards for the regional scorecard and let conditional formatting turn every region's variance green or red.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Plan the Dashboard: Questions, KPIs & Layout Locked
- KPI Cards with Green/Red Rules Locked
- The Trend Chart: This Year vs Last Year Locked
- Category Breakdown: A Sorted Bar Chart with Labels Locked
- Sparklines: A Trend in Every Region Row Locked
- Target vs Actual: Combo Charts & the Secondary Axis Locked
- A Month Picker: INDEX/MATCH & SUMIFS-Driven KPIs Locked
- Final Project: The One-Page Sales Report Locked