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, beween, 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

Watch more Excel tutorial videos: https://www.youtube.com/playli....st?list=PLlKpQrBME6x
- Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com

As full disclosure, I work at Microsoft as a full-time employee.