Hello Everyone,

I used the following code in the Conditional Fomatting dialog box to acheive
alternate colour lines:

=MOD(ROW(),2)=1

This works fine, except when I choose a custom view, the alternate lines do
not re-color themselves and I get blocks of one color or another - looks
messy...

Does anyone know how to fix this?

Thanks