Conditional Formatting in Excel – Recorded Webinar
In this month’s webinar, you will learn how to use conditional formatting in Excel to help you highlight important data visually and identify patterns and trends within your spreadsheets.
Join your Excel expert, David Casuto, as he walks you through various conditional formatting preset rules and how to manage rules. He will also teach you how to create your own rules to highlight blank cells, use formulas, and much more.
This webinar covers the following:
- What is conditional formatting?
- Using preset rules
- Highlight Cells Rules
- Top/Bottom Rules
- Manage Rules and Clear Rules
- More preset rules
- Data Bars
- Color Scales
- Icon Sets
- Blanks cells
- Working with formulas
- Comparing values within a dataset
- Highlighting rows
- BONUS: Using COUNTIF and wildcard
Watch the session here, and download the instructor demo file to follow along.
Conditional Formatting in Excel – Recorded Webinar
Download the instructor files and follow along.
Other Microsoft Webinars:
Add Interactivity with Form Controls in Excel
Create Formulas with LAMBDA in Excel
Please visit our free Microsoft Office resources center for more high-quality Microsoft guides.
Simon Calder
Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA.He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!
