coloring overy other line without doing so line by line

G

Guest

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

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
 
G

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
 
G

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

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top