How to alternately variegate rows

[lawrencae]

How can I alternately variegate rows. I want to make every other row white
and every other row off white so the rows can be easily differentiated?

Also, since my document already has over 450 rows, is there a simple way to
alternately veriegate these rows?

This is a great group. I have been helped many times here. I thank you in
advance for any help you might give me with this issue.

 

[Bob I]

Pick one of the methods listed here.
http://www.google.com/search?hl=en&q=shade+excel+rows&aq=f&oq=

 

[Gord Dibben]

You can use Conditional Formatting.

Select 500 rows then............

Format>CF>Formula is

=MOD(ROW(),2)=1 Note: this will not survive Filtering

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Will survive filtering

Pick the one color only. Default will be no color(white)


Gord Dibben MS Excel MVP