http://www.ozgrid.com/Excel/alternate-row-color.htm
--
If this post helps click Yes
---------------
Jacob Skaria


"jrgspyder" wrote:

I am trying to alternate shading of rows in Excel 2007, without creating a
new row and changing the formatting. I am not interested in sorting the data
using this, only alternating the shading. I am able to do this with Excel
2003 on other computers but cannot figure it out in the newer version. Is
this possible?