Topics/Tables, Pivots, Formatting and Data Tools

Conditional Formatting

Premiumadvanced 15 min4 tasks0/48 pts

Conditional formatting changes how a cell looks based on its value, so patterns jump out. Select a range, open Conditional in the Data tools bar, pick a rule (Greater than, Top N, Text contains, Data bars…) and a fill colour.

Common mistakes

Applying the rule to the header row too.
Typing the threshold into the rule when it should live in a cell you can change.

Tables Skill Summary Sorting and Custom Sort