Thread: keeping background "stripes" in order after sort

Hi

I have a worksheet with alternate "stripes" in the background to make fairly long rows easier to follow (Some of the cells in each row also have conditional formatting applied which changes the cell colour). When I apply the sort function to the worksheet the "stripes" are moved as well and are no longer in order, is there a way to retain an alternate background colour to rows even after the sort function is applied? (I am using excel 2003)

Thanks

Try conditional formatting, with a formula like this:

=MOD(ROW(),2)=0

Many thanks Stephen....works a treat

Regards