Magic Formula for Conditional Formatting of Rows

Good information about formatting excel stuff can be found at the Contextures website.

Multiple Rows
=MOD(ROW()-3,5*2)+1<=5 Shade Alternating Rows

You can use conditional formatting to shade alternating rows on the worksheet.

1. Click the Select All button, above the Row 1 button, to select all the cells on the worksheet.
2. Choose Format|Conditional Formatting
3. From the first dropdown, choose Formula Is
4. For the formula, enter =MOD(ROW(),2)
5. Click the Format button.
6. On the Patterns tab, select a colour for shading
7. Click OK, click OK