How do I maintain alternate row shading after inserting a new row

[Scott Wonser]

How do I maintain alternate row shading after inserting a new row in Excel.
On some of our printed documents such as phone lists we like to have
alternate shaded rows. Currently, when we insert a row it compies the
format of the previous row so we end up with two shaded rows together. Not
the look I want.

 

[Pete_UK]

Are you manually shading those rows? You could do it using conditional
formatting (i.e. shade every odd row), and this will adjust when a row
is inserted as the new row will take the format of the row above (as
you have pointed out).

Hope this helps.

Pete

 

[Bob Phillips]

See http://xldynamic.com/source/xld.CF.html#rows

 

[Jim Thomlinson]

Instead of hard coding your formats use conditinal formatting. Instead of
Cell is Change to Formula is and add a formula like

=mod(row(), 2)=0

Now add your format and your spreadsheet should be dynamically formatted.

 

[Gord Dibben]

If you will be doing any filtering on the sheet, this formula will survive the
filtering process.

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


Gord Dibben MS Excel MVP