I know about setting conditional formatting for "this month", "next month" and "last month" but it does not really do what I want because if the date is more than 30 days overdue the formatting will not apply to the cell. Here's my question. I have a date entered in say Cell A1 which automatically tells Cell B1 to set the date 90 days ahead. In Cell B1 I want to use conditional formatting so the cell will be yellow if the date is this month, red if the date has passed, and blue if the date is next month. I'm not sure it's possible though because if I complete the project today (by due date) I will enter today's date in Cell A1 which starts the calculation over again. Make sense? I'm trying to find a way to alert myself that I have something due this month, it's overdue, or it's coming up. Is there a formula that will allow me to do this?
Example:
Cell A1 data Cell B1 data
6/6/16 (automatically calculates 6 months ahead) 12/6/16
This month it would be Yellow because it's due. If I did not complete it this month or next it needs to be red. If I complete it I will enter the date completed in Call A1 which will recalculate B1. I'm sure it's much easier than I'm explaining it but I'd appreciate some guidance.
Anthony
Example:
Cell A1 data Cell B1 data
6/6/16 (automatically calculates 6 months ahead) 12/6/16
This month it would be Yellow because it's due. If I did not complete it this month or next it needs to be red. If I complete it I will enter the date completed in Call A1 which will recalculate B1. I'm sure it's much easier than I'm explaining it but I'd appreciate some guidance.
Anthony