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.