Select the range of cells you want to shade
Go to the Home tab
Click Conditional Formatting
Choose New Rule
Select 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 a fill color
Click OK
Click OK again