Highlight one cell colored and one cell not. Click format painter (the paint
brush on the tool bar) and then paint the area you want colored.
HTH

"gen" wrote:

There is data entered into the cells all-ready. If I do the copy, it will
erase the data. Any suggestions?
Thanks for the help.

"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.