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.
Bookmarks