Forum Discussion

Copper Contributor

Dec 16, 2020

Solved

Highlighting an anniversary date for 30 days

I have applied this conditional formatting =(MONTH(TODAY())=MONTH(B5))*(DAY(TODAY())=DAY(B5)) and it works like a charm!! However, I cannot seem to figure out how to add in the formula for the cell(s...

excel

mtarler
Dec 16, 2020
Life_is there are lots of ways to do it, but how about:
=(ABS(TODAY()-DATE(YEAR(TODAY()),MONTH(B5),DAY(B5))-15)<=15)

mtarler

Silver Contributor

Dec 16, 2020

Life_is there are lots of ways to do it, but how about:

=(ABS(TODAY()-DATE(YEAR(TODAY()),MONTH(B5),DAY(B5))-15)<=15)

Life_is
Copper Contributor
Dec 16, 2020
mtarler you are the best!!! Thank you so much!!! That did it!!! I have been at this for several hours!! Thank you! Thank you! Thank you!