Matt, use conditional formatting



Select the range you want to format. Format Conditional Formatting. In the
left dropdown, change ""Cell Value is"" to ""Formula Is"". In the formula
box type. =MOD(ROW(),2)=0 Click the ""Format..."" button. Click the
Patterns tab and pick a color.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Matt8301" wrote in message
...
how do i shade alternating rows in excel without going through one by one?
thanks