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