How to reset every other row color after sorting

T

Trish

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
 
G

Gord Dibben

Conditional formatting.

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Background stays when sorting 2
Worksheet Layout 2
Shade Every Other Row 2
autoformat add or change 1
Insert Cells every other row 1
background-color every second row 2
Sorting every other line 2
Changing Row Color 13

Top