Microsoft Office Tutorials and References

In Depth Information

Figure 19-17:
Conditional formatting produces these groups of alternate shaded rows.

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)

Displaying a total only when all values are entered

Figure 19-18 shows a range with 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 are nonblank. The conditional formatting formula

for cell C6 (and cell C5, which contains a label) is

=COUNT($C$2:$C$5)=4