To create alternate row colors in Excel.

• Highlight the range of cells to format.
• Choose Conditional Formatting from the Format drop down menu
• Select Formula Is from the first drop-down list box, and enter =MOD(ROW(),2)=0 in the second box.
• Click the Format button, select the Patterns tab and specify a color for the shaded rows.
• Use the other tabs to make any other modifications
• Click OK twice to return to your worksheet.

By using a formula, the formatting is dynamic and can handle deleting rows without affecting the other rows formating.