11 July 2015
If you've ever applied conditional formatting with your own formula, you know the hardest part is making sure the formula actually works. The problem is that the formula area in a conditional formatting rule isn't very friendly. You don't get highlighted cell references, you don't get function autocomplete...heck....you don't even get screen tips.
Luckily, there's an easy fix: use dummy formulas to test your conditional formatting.
Full article: Test conditional formatting with dummy formulas
