is there a way of keeping alternat rows differently coloured
 

please help,
is there a way that when you insert a row in a range of cells it
automatically keeps alternative rows coloured, say grey and white. currently
my 2003 excel inserts a white row.
thanks

is there a way of keeping alternat rows differently coloured
 

Use conditional formatting something like this...

Select the rows where you want the alternating bands of colour.
From the menu select Format - Conditional Format
change from Cell Is to Formula Is
Add the formula
=mod(row(), 2)
Change the format pattern to light grey.
That should do it...
--
HTH...

Jim Thomlinson


"des-sa" wrote:

please help,
is there a way that when you insert a row in a range of cells it
automatically keeps alternative rows coloured, say grey and white. currently
my 2003 excel inserts a white row.
thanks

is there a way of keeping alternat rows differently coloured
 

Select a gaggle of rows then..........

FormatConditional FormattingFormula is:

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

Pick a gray from the FormatPatterns


Gord Dibben MS Excel MVP

On Fri, 16 May 2008 15:13:00 -0700, des-sa
wrote:

please help,
is there a way that when you insert a row in a range of cells it
automatically keeps alternative rows coloured, say grey and white. currently
my 2003 excel inserts a white row.
thanks

is there a way of keeping alternat rows differently coloured
 

This is a little off-topic, but more basic, so hopefully one of you can help:
Whenever I create borders in Excel 2007, then save and close, the borders
disappear when I reopen the document. Thanks very much.

"Gord Dibben" wrote:

Select a gaggle of rows then..........

FormatConditional FormattingFormula is:

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

Pick a gray from the FormatPatterns


Gord Dibben MS Excel MVP

On Fri, 16 May 2008 15:13:00 -0700, des-sa
wrote:

please help,
is there a way that when you insert a row in a range of cells it
automatically keeps alternative rows coloured, say grey and white. currently
my 2003 excel inserts a white row.
thanks