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