Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-18: Using conditional formatting to produce a checkerboard effect.
Displaying a total only when all values are entered
Figure 19-19 shows a range with a formula that uses the SUM function in cell C6. Conditional
formatting is used to hide the sum if any of the four cells above is blank. The conditional formatting
formula for cell C6 (and cell C5, which contains a label) is
This formula returns TRUE only if C2:C5 contains no empty cells.
Figure 19-19: The sum is displayed only when all four values have been entered.
Figure 19-20 shows the worksheet when one of the values is missing.