Microsoft Excel - Shade Alternate Rows

Have you ever wanted to apply shading to a specific range of cells or your entire worksheet?  Follow these steps.  

1. On the worksheet, do one of the following:
• To apply the shading to a specific range of cells, select the cells you want to format.
• To apply the shading to the entire worksheet, click the Select All button.
2. On the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then click New Rule.
3. In the New Formatting Rule dialog box, under Select a Rule Type, click Use a formula to determine which cells to format.
4. In the Format values where this formula is true box, enter =MOD(ROW(),2)=0.
5. Click Format. 
6. In the Format Cells dialog box, click the Fill tab.  Select the background or pattern color that you want to use for the shaded rows, and then click OK.