Hi,

Donig it on a filtered range is a variation on the formula you are using.
Select your range and use this
=MOD(SUBTOTAL(3,$A$1:$A2),2)

Apply the filter and alternate rows should be coloured. Change A1 A2 to the
top of your range.


Mike

"Monk" wrote:

Hi

I can color alternate rows with the mod(row();2)=0 condition however my
worksheet also incorporates the use of hiding rows where a column value is
blank. This has the effect of distorting the colored rows. I understand there
is a condition you can use for filtering but I don't want to go down that
path. Is there a formatting conditon or vba code that will give me the
alternate row colors after hiding the rows?