Excel like a finance pro.
← The libraryPractice · 2 questions →
Formatting shortcut
Open the conditional formatting menu
Alt, H, L on Windows, None on Mac.
OccasionalDifficulty 1100 · Proficient
When to use it
Opens the Conditional Formatting menu on the Home tab.
The shape of it
- Windows
Alt, H, L
- Mac
None
Worked examples
Data bars
Select numbers, Alt, H, L, then D (data bars) → In-cell bars
Visual comparison.
Highlight rule
Alt, H, L, H (highlight rules), G (greater than) → Highlight over a threshold
Exceptions.
Formula rule
Alt, H, L, N → New Rule with a formula
Anything data-driven.
Worth knowing
- Formula rules like =$C2="Late" format the whole row when written on the full range.
- Manage Rules shows every rule on the sheet.
- Stop If True controls rule order.
Where it goes wrong
- Many rules slow a sheet.
- Rules copied by fill-down multiply into fragments; clean up in Manage Rules.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.