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