how to make alternate color Rows and Column in excel

How to make alternate color Rows or Column  in excel
It I how to shade every other row or Column in Excel    by using the "Conditional Formatting" follow these steps:

1. Open the worksheet.
2. Select the cell range of your rows or columns that you want to shade, .
3. Click the Home tab.
4. In the Styles group, click Conditional Formatting, and then click Manage Rules.
5. Click New rule.
6. Click Use a formula to determine which cells to format.
7. In the Format values where this formula is true box, type =MOD(ROW(),2), and then click Format.
8. On the Fill tab, click the color that you want to use to shade every other row, and then click OK.
9. Click OK to close the New Formatting Rule dialog box.
10. Click Apply, and then click OK to close the Conditional Formatting Rules Manager dialog box.

Posted in: Computer Skill