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

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.
 
P

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
 
J

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.
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top