8 Expert Tricks for Conditional Formatting in Excel

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and tricks that will have you making custom formulas for conditional formatting that can do everything from the most basic, to multi-conditional formulas across spreadsheets.

This is a great tutorial to watch to brush-up on your conditional formatting skills or to dramatically improve them. After viewing this, you should feel comfortable making almost any kind of custom formatting rule, and then implementing it, and troubleshooting it, if an error arises.

Enjoy!

[sunglee]

You do a much better job of explaining this than others. Thanks.

[yickwong]

I have tried different channels and your tutorials are the best. THE BEST. Much appreciated.

[andrewbouc]

I don't even know why I waste time on other Excel youtube videos. Your content is in a rare group of simply explained but not at all painfully obvious. Perfect for an intermediate user like me!

[nsanerydah]

You solved my problem and I didn't even realize that your example worked. Great job! Thanks a bunch.

[jaxattax]

thank you so much for this! definitely need this as a refresher n your voice is great for teaching this, very calm n articulate too :)

[rajeevgosavi]

Good John, very impressive. Made complex things look very simple. Great!

[TeachExcel]

200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

[Rais]

Fantastic tutorial !! Very precise and accurate delivery. god bless for your act of kindness. Thank you very much.

[thebesttechnical]

Great and easy way of explaining the
topic, thank you very much.

[praveenkumar_]

Amazing video and got to know more about conditional formatting using dynamic formulas!! and got an opportunity to hands-on practice along!!😍😍

[nickwhite]

Many thanks, your instructions taught me exactly what I have been searching for

[mohammedziyadpa]

Applying the conditional format to other sheets is crazy…. Thank you very much ❤

[kxqgxwn]

Great presentation and good contents to learn.
Thank you !

[cocorajschaperderalderwere]

Amazing excel video, I could not figure out what is was doing wrong in my formula’s. Only to watch this video and it being explained perfectly. Thanks you, bravo.

[michaeloloishuro]

Very simplified demonstration on a hard conditional formatting topic.
Thanks.

[nairobi]

By far the best explanation I found so far...

[-th_CAV]

@TeachExcel, Thanks for your clear and understandable explanation of conditional formatting. I have used this type of formatting on several different spreadsheets and in varying ways. One thing I have a hard time understanding is when you use multiple formats on the same sheet and a given format essentially cancels out the other formats, i.e. if you have 6 formats and only one of the 6 is "true" and all of the remaining formats are "false", what is the purpose of the "Stop If True" option check-box on the right side of the dialog box, an how is it used?

[sereyvanny]

Thank you so much!!! I had to do this today, and I wasn't able to get it to work right, and your video helped me fix my issue.

[azizniazi]

Really informative video

Special thanks

[irfanmeghani]

Thanks. It's very informative. Looking forward to your next tutorial.