Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-17: Using conditional formatting to apply formatting to alternate 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.
=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)
Creating checkerboard shading
The following formula is a variation on the example in the preceding section. It applies formatting
to alternate rows and columns, creating the checkerboard effect seen in Figure 19-18.
=MOD(ROW(),2)=MOD(COLUMN(),2)
 
Search JabSto ::




Custom Search