coloring overy other line without doing so line by line
 

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

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.

Use Conditional Formatting off the Format menu

Select/highlight the range you want to format, then use the menu to call up
the Conditional formatting dialog

Select 'Formula Is' rather than 'Cell Value Is' and enter this formula

=mod(row(),2)=0

Then click on the format button, go to the pattern tab, and choose the color
you want the rows to be shaded. Click on OK & you're done!

Duke

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

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.

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.

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.