how do i shade alternating rows in excel without going through one by one?
thanks

Matt8301 wrote:
how do i shade alternating rows in excel without going through one by one?
thanks
Conditional Formatting will take care of this problem

1) Select your data/range of cells

2) Format Conditional Formatting

3) Condition 1 Formula Is =MOD(ROW(),2)=1, and choose you
formatting

4) Condition 2 Formula Is =MOD(ROW(),2)=0, and choose you
formatting
5) Click Ok


--
Message posted via http://www.officekb.com

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