Conditional formatting is a powerful feature in Excel, and something you can use in a variety of scenarios.
In a hands-on tutorial, I’ll show you four different examples of how to work with conditional formatting, including color scales (for temperature data), icon sets (for student grades), highlighting cell rules (for project status) and data bars (for project status).
00:00 – Overviewing four examples of conditional formatting in Microsoft Excel
00:22 – Example #1: Working with color scales for temperatures
02:27 – Example #2: Working with icon sets for student grades
04:34 – Example #3: Highlighting cell rules for project status
06:56 – Example #4: Working with data bars for project status