Microsoft Office Tutorials and References
In Depth Information
Figure 19-16: Using conditional formatting to apply formatting to alternate rows.
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 a checkerboard effect.
=MOD(ROW(),2)=MOD(COLUMN(),2)
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)
Figure 19-17 shows an example.
Search JabSto ::




Custom Search