Cross-Field Rules: End ≥ Start and Shares = 100%
This lesson is part of the course
In this lesson
You validate Larkspur's project budget template where one cell depends on another: end date after start date, and the cost shares of three departments adding up to exactly 100%.
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
- Number & Date Rules as Check Formulas Locked
- List Rules: Allowed Values with COUNTIF & MATCH Locked
- Dependent Lists: Category → Item with INDEX/MATCH Locked
- Text Length & Pattern Checks: LEN, LEFT, SEARCH Locked
- Duplicate Prevention: COUNTIF & COUNTIFS Rules Locked
- Cross-Field Rules: End ≥ Start and Shares = 100% Locked
- Input Form with Error Messages & an Error Summary Locked
- Template Protection Checklist & Completeness Dashboard Locked