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/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– 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.
source