How do I shade every other row in Excel 2007?
In Excel 2007, here is step-by-step instruction for shading every other row in your selection:
1. Select the rows or cells in Excel you want affected
2. Under the "Home" tab, click on the "Conditional Formatting" drop-down and select "New Rule..."
3. Select the option, "Use a formula to determine which cells to format"
4. Copy and paste the following values into the field for "Format values where this formula is true:"
=MOD(ROW(),2)=1
5. Click on the "Format..." button to format the row style desired (Use the "Fill" tab to insert cell background color) and press OK
6. Click OK again and voila!
