Project 5: Number Formats and Conditional Formatting
This lesson is part of the course
In this lesson
Suggested time: 10 minutes. You add a % change column to Fernhill's regional unit sales and apply three conditional-formatting rules: a threshold, a text rule and a top-N rule.
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
- Project 1: Cell References and a Tax-Rate Cell Locked
- Project 2: SUM, AVERAGE, COUNT, MIN and MAX Locked
- Project 3: CONCAT, PROPER, UPPER, LEFT, RIGHT and LEN Locked
- Project 4: IF, Nested IF and IF with AND Locked
- Project 5: Number Formats and Conditional Formatting Locked
- Project 6: Create and Modify Charts Locked
- Project 7: Sort and Filter Logic with RANK.EQ, COUNTIF and LARGE Locked
- Project 8: Timed Mixed Project (20 Minutes) Locked