Microsoft Office Tutorials and References
In Depth Information
Creating checkerboard shading
Figure 19-1: 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. Figure 19-2 shows the result.
=MOD(ROW(),2)=MOD(COLUMN(),2)
Figure 19-2: Conditional formatting produces this checkerboard effect.
Search JabSto ::




Custom Search