This will happen if your patterns are manually applied. It would be
better to remove that manual shading and to apply background colours
using conditional formatting, the condition being if the row number is
even (or odd) then colour the cell - the CF formula would be something
like:

=MOD(ROW(),2)=0

for even-numbered rows.

Hope this helps.

Pete

On Apr 6, 3:30*pm, Dan wrote:
I have a worksheet where every other row has a 'pattern' in it to help make
it easier to read across the spreadsheet.

The problem I'm running into is as I add new rows at the bottom of the
spreadsheet and then resort them into their correct place, the patterns go
with the sort and now the patterns have to be redone again the get them back
to every other row.

Any suggestions?