Well... to use conditional formatting to color your rows, just in case you
get tired of the table stuff... and for anyone else reading this that has '07:
Select your range.
On the Home Tab, in the Styles Section, click Conditional Formatting.
Select New Rule.
Click Use a formula to determine which cells to format.
Enter the formula:
=MOD(ROW(),2)=0
click the Format button and Fill tab to set a background color of your choice.
Click OK and OK and admire your handiwork!


"Jeff" wrote:

Well I tried what you guys said it wasnt working. However what I did was in
ms excel 07 underneath conditional formatting on the HOME tab I clicked
format as a table and there was different layouts of colors and that
worked....thanks

"MartinW" wrote:

Hi Jeff,

Check out this link
http://xldynamic.com/source/xld.CF.html#rows

HTH
Martin