Without a macro, use conditional
formattingcondition1=mod(row(),2)=0format patterns graycopy the format.
easier when you add and delete


--
Don Guillett
SalesAid Software

"Jason" wrote in message
...
I have the following Range: "A10:Z2000". I am trying to figure out some
code that would allow me to begin with row 10 within the range, and
highlight
every other row with a light shade of grey until it reaches the end of the
range. Some of the cells will have other formats in place (Number,
Percentage, etc), so I would want the shading to occur with the existing
formats remaining in place. Can anyone help. Thanks.

Jason