Microsoft Office Tutorials and References
In Depth Information
This formula returns TRUE only if C2:C5 contains no empty cells. The conditional formatting applied is a dark
background color. The text color is white, so it's legible only when the conditional formatting rule is satisfied.
Figure 19-19 shows the worksheet when one of the values is missing.
Figure 19-18: The sum is displayed only when all four values have been entered.
Figure 19-19: A missing value causes the sum to be hidden.
Using custom functions in conditional formatting formulas
Excel's conditional formatting feature is very versatile, and the ability to create your own formulas to define the
conditions will cover most needs. But if custom formulas still aren't versatile enough, you can create custom
VBA functions and use those in a conditional formatting formula.