Formula-Based Rules: Overdue Invoices & Banded Rows
This lesson is part of the course
In this lesson
You test the overdue formula in a helper column, turn it into a whole-row formula rule, add every-other-row banding and total what is late.
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