Conditional formatting is one of the functions that Son Han presented in his Top Excel Formulas class. He did go a bit fast at times, but that's the beauty of videos--you can pause and replay certain sections.