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.