How to alternately variegate rows
You can use Conditional Formatting.
Select 500 rows then............
FormatCFFormula 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
On Wed, 27 Aug 2008 06:34:01 -0700, lawrencae
wrote:
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.
|