coloring overy other line without doing so line by line

[Guest]

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

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

 

[Gord Dibben]

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