Highlight Alternate Rows by Conditional Formatting - Advanced Conditional Formatting

You can highlight alternate rows by selecting the range that you want to format then Choose Format then select Conditional Formatting and In the Conditional Formatting dialog box, select Formula Is from the drop-down list, and enter the formula
which is shown in the tutorial then Click the Format button, select the Patterns tab, and specify a color for the shaded rows.