I think that's covered in www.cpearson.com, www.contextures.com, and/or
other Excel web sites. It uses Conditional formatting.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Ian James" wrote in message
.. .
I would like to set odd and even rows in Excel with clear and darker
background colors in order to better read long rows of numbers. I know I
can do this manually by setting background of rows individually.

My first question is whether there is a way to set this automatically for
an entire worksheet?

My second question is how those alternate shadows are called. Do we
usually talk about guidelines, grid lines or something else?