LevelTen Interactive

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!

Login or register to tag items
Syndicate content

©1999 - 2010 LevelTen Interactive - Dallas, TX