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
Kevin Stratvert 