How to select only odd/even numbered rows to be shaded
 

I am working with a pretty large worksheet and would like to select ONLY the
odd or even numbered rows so that i can shade them. Can someone offer #1 -
how to select these certain rows and #2 - how to format them?

Thanks

How to select only odd/even numbered rows to be shaded
 

See http://www.xldynamic.com/source/xld.CF.html#rows

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Skott" wrote in message
...
I am working with a pretty large worksheet and would like to select ONLY
the
odd or even numbered rows so that i can shade them. Can someone offer
#1 -
how to select these certain rows and #2 - how to format them?

Thanks