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