if your spreadsheet in 07 is set to everyother row color and you do a
different sort ...is there an easy way to reset that every other row? I've
tried reseting the table but it won't change the row colors ....My fall back
is to use the format painter but there has to be an easier way for this in 07
(I think in 03 you could just change the autoformat agian)

Thanks for the response

Conditional Formatting/ Formula is/ =MOD(ROW(),2)
--
David Biddulph

"Trish" wrote in message
...
if your spreadsheet in 07 is set to everyother row color and you do a
different sort ...is there an easy way to reset that every other row?
I've
tried reseting the table but it won't change the row colors ....My fall
back
is to use the format painter but there has to be an easier way for this in
07
(I think in 03 you could just change the autoformat agian)

Thanks for the response

Conditional formatting.

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


Gord Dibben MS Excel MVP

On Wed, 18 Nov 2009 09:35:01 -0800, Trish
wrote:

if your spreadsheet in 07 is set to everyother row color and you do a
different sort ...is there an easy way to reset that every other row? I've
tried reseting the table but it won't change the row colors ....My fall back
is to use the format painter but there has to be an easier way for this in 07
(I think in 03 you could just change the autoformat agian)

Thanks for the response