Conditional formatting

To format the rows of data so that adjacent rows are formatted differently, apply a conditional format. 

To do this, select cells A2:E10 and choose Format, Conditional Formatting. 

From the first dropdown list choose Formula Is and then type the formula: =Mod(row(),2)=0 

Select Format button and create a format for the first data row. 

Click Add and repeat the previous step using this formula: =Mod(row(),2)=1 

This creates a different format, which will be applied to odd numbered rows. Click OK when you are done.

Based on ideas from Helen Bradley, an authority on the web on Office packages.

This work may be freely copied for non-commercial use only. Copyright © Pam Miller