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


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Monk" wrote in message
...
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?