If you want the row banding to remain through filtering use this formula where
the others have showed you.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0


Gord Dibben MS Excel MVP

On Mon, 17 Mar 2008 20:01:00 -0700, STS wrote:

Hi,

How can I shade multiple rows at the same time, for example all odd row
numbers in gray, all even numbers in blue? I am sure there is a better way of
doing it than manualy row by row. Thank you for your help.