Derek

This will work but if a row is inserted or deleted, the formatting gets out of
whack.

Best to use Conditional Formatting as Duke's post explains.

Then insert/delete rows will not mess with the alternate row formats.


Gord Dibben Excel MVP

On Fri, 1 Apr 2005 08:39:04 -0800, "Derek"
wrote:

Highlight the first and second row (One colored, one not) Right click and
copy. Highlight the range you want to format then Right clickpaste
specialformats
HTH
Derek

"gen" wrote:

Need to format many worksheets...need to color every other line..is there a
way of doing so without going line by line.