In this video we discuss “Conditional Formatting in Excel”. Conditional Formatting is one of the most simple yet powerful features in Excel Spreadsheets. As the name suggests, you can use conditional formatting in Excel when you want to highlight cells that meet a specified condition. It gives you the ability to quickly add a visual analysis layer over your data set. You can create heat maps, show increasing/decreasing icons, Harvey bubbles, and a lot more using conditional formatting in Excel.

• 00:00:00 Introduction
• 00:02:00 Agenda
• 00:02:36 Formatting
• 00:03:06 Conditional Formatting
• 00:07:22 Formatting in Excel
• 00:12:18 Data Bars
• 00:14:35 Color Scales
• 00:17:50 Icon Sets
• 00:20:08 Cells that contain
• 00:26:06 More rule type
• 00:32:27 Formula based
• 00:35:03 Google Sheets
• 00:35:28 Color Scales
• 00:37:56 Top/Bottom values
• 00:40:19 Unique and similar values
• 00:42:23 Greater than
• 00:44:47 Summary

#excel