Microsoft Office Tutorials and References
In Depth Information
Working with Conditional Formats
For different sized groups, change the 4 to some other value. For example, use this formula
to shade alternate groups of two rows:
=MOD(INT((ROW()-1)/2)+1,2)=1
Displaying a total only when all values are entered
Supppose a range has a formula that uses the SUM function in cell C6. Conditional
formatting is used to display the sum only when all of the four cells above aren’t blank. The
conditional formatting formula you would apply to cell C6 (and cell B6, which contains the
label for the row) is:
=COUNT($C$2:$C$5)=4
This formula returns TRUE only if C2:C5 contains no empty cells. The conditional
formatting applied to B6:C6 is a dark background color. The text color in those cells is
white, so it’s legible only when the conditional formatting rule is satisfi ed. Figure 19.25
shows the worksheet when one of the values is missing.
FIGURE 19.25
A missing value causes the sum to be hidden.
Working with Conditional Formats
This section describes some additional information about conditional formatting that you
may fi nd useful.
Managing rules
The Conditional Formatting Rules Manager dialog box is useful for checking, editing,
deleting, and adding conditional formats. First select any cell in the range that contains
conditional formatting. Then choose Home
Styles
Conditional Formatting
Manage
Rules.
 
Search JabSto ::




Custom Search