Hi,
Sorry to bother everyone but I have been trying to figure this one out for hours and can't seem to do it.

Does anyone know how to combine 2 conditional formats?

I'm trying to shade every other row grey so its readable with this:

=MOD(ROW(),2)

But, at the same time, would like to highlight upcoming expiry dates with this:

=AND(A2-TODAY()>=0,A2-TODAY()<=30)


I've tried to combine them by using and(mod...., and....) but that didn't seem to work. Any help would be much appreciated.