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

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

[aumpatil]

For those who do not know, this dude was literally the product manager for Microsoft Office 🙌

[dwyn]

Another perfect video, with exactly the answer to the question, accurate to the title of the video, no delays, no distractions... GLORIOUS!!!

[MadhulataBisht]

Thank you Kevin! Your videos are always to the point and easy to follow. :)

[rubymoore]

Thanks Kevin, you always provide helpful tips and step by step instructions!

[preksha.choudhary]

You have helped me so much! anytime, i fear i do not anything in Excel or PowerBI, I always search for your videos! You are AMAZING! Keep going! <3

[maryharnett]

Thanks Kevin - literally learned conditional formatting in a few minutes from this video - I am going to put it into practice from today. So useful. 😊

[tgdkluge]

You have excellent training and instructing skills!

[katynmm]

Appreciate your excel videos SO MUCH!!

[teoxengineer]

The information of condutional formating which you gave to us is so limited and basic level. Its functionality is so huge. I’ m looking forward to advanced level of it 👍
Thank you

[gideonsvictory]

Thanks Kevin I can always count on your lessons.

[devikadinesh]

thank you so much! all your videos are a lifesaver!

[nielspeelen]

Thank you so much for this easy to understand tutorial!

[jmjmusic]

Great!!!! Learning fast with your way of teaching. Thanks!!!

[sabahatafsheen]

You are the best at teaching excel. Thank you! :)

[stephanieboekhoudt]

Youre just amazing and you saved my test tomorrow. ONGOD I LOVE YOU SO MUCH RN. BLESS YOU

[MonRojasOfficial]

Great video and examples. Thank you!! :) Greetings from a Costa Rican singer!

[maryadebimpe]

You made use of Interesting examples 😊. This was so easy to understand.

[ejridiissam]

Thank you for the explanation
It was really useful

[brochestedbs]

Great Video. I could immediately do what I wanted to. Thanks !!!

[mx]

Thank you for getting me through my homework!