=AND(COLUMN()<=5,MOD(ROW(),2)=1)
This code will make the colouring stop after column E. Adjust the
number as you see fit.
--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile:
http://www.excelforum.com/member.php...o&userid=34322
View this thread:
http://www.excelforum.com/showthread...hreadid=550688