I am trying to format cells when the month in the date is equal to or grater than the month in todays' date.
I can do it by using month only formula, but then it also highlights the dates in years past. I want to high light only for yeas going forward.
This is the formula i have so far build. But it does not seem to to work.
="(Year($D2)MONTH($D2))=MONTH(TODAY( ))"
Bookmarks