Formatting Dynamic Spilled Array Formulas so that Formatting Follows Spill! Excel Magic Trick 1723

Download Excel File: https://excelisfun.net/files/EMT1721-...
Learn how to use Conditional Format your spilled array formula so that if the formula spills new values, the formatting spills also!

Topics:
1. (00:00) Introduction
2. (00:25) Formula #1. Logical Formula that uses NOT Operator and Zero Length Text String.
3. (02:17) Go To All Conditional Formatting in Worksheet Trick. Bonus Trick #1.
4. (02:40) Formula #2. Use NOT and ISBLANK functions. Bonus Trick #2.
5. (03:43) Summary, Closing and Video Links