Select the range of cells you want to shade
Go to the Home tab
Click Conditional Formatting
Select New Rule
Choose Use a formula to determine which cells to format
Enter the formula `=MOD(ROW(),2)=0` for even rows or `=MOD(ROW(),2)=1` for odd rows
Click Format
Choose the Fill tab
Select the shading color you want
Click OK
Click OK again