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

  • Thread starter Thread starter Scott Wonser
  • Start date Start date
S

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.
 
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
 
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.
 
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
 
Back
Top