Apply shading to alternate rows or columns in a worksheet
In the Format values where this formula is true box, enter =MOD (ROW (),2)=0, as shown in the following illustration. Click Format. 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.
DA: 64 PA: 94 MOZ Rank: 21