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