protect row color

[KIRK]

I have a spread shhet that I have alternating row colors.
If I do a data sort it moves the color along with the
data.
How do I protect the rows format so this does not happen

 

[Bernard V Liengme]

Sounds as if the rows were coloured manually.
Remove the colours, select the rows to shade using Format|Conditional
Formatting.
One way to specify every second row is MOD(ROW(),2)=0

Bernard

 

[Ron de Bruin]

See this example

http://www.cpearson.com/excel/banding.htm

 

[kirk]

Thanks Bernard
I got this too work once
Now I can't duplicate
MOD(ROW(),2)=0