A way to modify pattern applied to every other row

  • Thread starter Thread starter bam
  • Start date Start date
B

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
 
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
 
Thanks very much!

Gord Dibben said:
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
Click to expand...
 
Back
Top