Microsoft Office Tutorials and References
In Depth Information
Shading groups of rows
Shading groups of rows
Here’s another row shading variation. The following formula shades alternate groups of rows. It
produces four rows of shaded rows, followed by four rows of unshaded rows, followed by four more
shaded rows, and so on. Figure 19-3 shows an example.
=MOD(INT((ROW()-1)/4)+1,2)
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)
Figure 19-3: Conditional formatting produces these groups of alternate shaded rows.
Search JabSto ::




Custom Search