Monthly PM's due

asked 2016-01-07 17:24:49 +0200

I'm attempting to make a spread sheet for our PM program. I need to know how to get the conditional formatting to work. I have it set up right now where if it shows a date past today it is green so not due and if it is before today it is red meaning it is due. What I would like is to set it up by the MONTH not the specific day, but also how to write it to include a yellow cell if it is due in the current month then red if it has past that month.

edit retag flag offensive close merge delete