Conditional formating for the month
I have a column with the birthday of some clients and I want the cell format
to change to yellow when his date of birth is withing the current and the
next monat. In order to do that I wrote these formula in the first and
second field of the conditional formating panel=C2=MONTH(TODAY()) and
=C2=MONTH(TODAY())+1 , but it doesn't work.
Can't you tell me what am I doing wrong
Thanks
|