A way to modify pattern applied to every other row

[bam]

Hello, I do see how to use the autoformat and List 1 to produce shading for
every other row.
Is there a way to modify the color of the shading?
Thanks very much in advance

bartmacl

 

[Gord Dibben]

Using List1 from the Styles dialog you will find that inserting/deleting rows or
sorting/filtering will mess up the alternate row formatting.

If you use Conditional formatting you can choose the color and the banding will
hold through the above functions.

Select a gaggle of rows then Format>Conditional Formatting>Formula is:

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

Format to a color you like and OK your way out.


Gord Dibben MS Excel MVP

 

[bam]

Thanks very much!

Using List1 from the Styles dialog you will find that inserting/deleting
rows or
sorting/filtering will mess up the alternate row formatting.

If you use Conditional formatting you can choose the color and the banding
will
hold through the above functions.

Select a gaggle of rows then Format>Conditional Formatting>Formula is:

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

Format to a color you like and OK your way out.


Gord Dibben MS Excel MVP