lundi 20 juillet 2020

If date is ___ function with conditional formatting

Looking for help with the following function.

I need to highlight a cell, IF today's date is 2 months prior to, or in the month of X.

For example. If today's date is in february, march, or april, highlight cell B2.

I'm trying to write a custom formula in the conditional formatting option. IF(A2=date(2/dd/yy),date(3/dd/yy),date(4/dd/yy))

Aucun commentaire:

Enregistrer un commentaire