Forum Discussion
Conditional Formatting using months instead of days
Hey Everybody, I work for an airline and for our due date tracking we use calendar months for due dates. With these calendar month due dates, you have a three month "grace" window to complete the e...
Hello Conquest441,
As an alternative to the answer provided by mathetes, you could use the following (not so elegant) conditional formats:
Starting in cell B4 of your table:
RED
=IFERROR(-DATEDIF(EOMONTH(B4,-1)+1,EOMONTH(TODAY(),-1)+1,"M"),DATEDIF(EOMONTH(TODAY(),-1)+1,EOMONTH(B4,-1)+1,"M"))=1
YELLOW
=IFERROR(-DATEDIF(EOMONTH(B4,-1)+1,EOMONTH(TODAY(),-1)+1,"M"),DATEDIF(EOMONTH(TODAY(),-1)+1,EOMONTH(B4,-1)+1,"M"))=0
GREEN
=IFERROR(-DATEDIF(EOMONTH(B4,-1)+1,EOMONTH(TODAY(),-1)+1,"M"),DATEDIF(EOMONTH(TODAY(),-1)+1,EOMONTH(B4,-1)+1,"M"))=-1