https://www.youtube.com/watch?v=_eZRkmRfVTM

Transcript by minute

00:00 — What is Conditional Formatting (intro + sponsor)

01:00 — Ribbon location and rule types overview

02:00 — Icon sets demo on monthly sales

03:00 — Apply per-row vs whole range; icon options

04:00 — Color scales explained

05:00 — Data bars and clearing rules

06:00 — Clearing and using Top/Bottom rules (Above Average)

07:00 — Below Average and Highlight Cells rules

08:00 — Duplicate Values rule demo

09:00 — Why duplicates formatting is so useful

10:00 — Using duplicates to find data issues

11:00 — Sort by color to surface duplicates

12:00 — Text that contains: quick keyword filters

13:00 — Use ‘Text that contains’ to catch bad formats