Conditional Formatting in Excel Tutorial

Learn how to use conditional formatting in Microsoft Excel in this step-by-step tutorial. I cover the following:

• Highlight cells, including greater than, less than, between, equal to, text that contains, a date occurring, duplicate values
• Top and bottom rules, including top 10 items, top 10%, bottom 10 items, bottom 10%, above average, below average
• Data bars
• Color scales
• Icon sets
• Custom rules