conditional formatting help please

[droo09]

Hi, I been using this conditional formula to create a gray line every other row:

=MOD(ROW(),2)=1

but I noticed when you sort, the lines do not re-format, so the gray lines get all jumbled. Is there a way to have to so when you sort, the same every-other line format stays? Thanks.

 

[Steve=True]

I highlighted a range, applied the condition, then sorted my data on a column and the conditional formatting stayed on the same rows it was before.