I think I did not explained what I need correctly. I need to color
alternating rows and once I move down to a cell that is empty, stop the
code. I need to use code because the spreadsheets we work with have
over 4000 rows and I really don't want to apply conditional formatting
to 2000 rows.

Besides, I need to include it as part of a macro I give to users. Also
the cells can have either letters or numbers.

thanks


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=502237