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
Search JabSto ::




Custom Search