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.
--
Thankyou, Scott.

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

On Jul 1, 12:11*am, Scott Wonser
wrote:
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.
--
Thankyou, Scott.

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

--
__________________________________
HTH

Bob

"Scott Wonser" wrote in message
...
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.
--
Thankyou, Scott.

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

Jim Thomlinson


"Scott Wonser" wrote:

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.
--
Thankyou, Scott.

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

On Mon, 30 Jun 2008 16:26:00 -0700, Jim Thomlinson
wrote:

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.