Colour Rows with Filter

You can colour rows even when using a filter.

Use this Conditional Format for odd rows

=MOD(SUBTOTAL(3,B$2:B2),2)=1

Use this Conditional Format for even rows

=MOD(SUBTOTAL(3,a$1:a1),2)=0



© Copyright andrewsexceltips.net All Rights Reserved.