Combining Rules & Rule Order: One Status, Three Colours
This lesson is part of the course
In this lesson
You resolve overlapping rules with one status formula – Red beats Amber beats Green – and colour the statuses of Brightwater's store scorecard.
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
- Highlight Cell Rules: Greater Than, Between, Text Contains Locked
- Top/Bottom Rules & Above/Below Average Locked
- Duplicate & Unique Values Locked
- Colour Scales: Two Heat Maps Locked
- Data Bars: In-Cell Bar Charts Locked
- Formula-Based Rules: Overdue Invoices & Banded Rows Locked
- Combining Rules & Rule Order: One Status, Three Colours Locked
- Capstone: KPI Table with Sparklines, Rules & a Chart Locked