I am having problems setting up the conditional formatting for a "To-Do" type of list. I want to assign tasks to be completed on Excel 2010 spread sheet, set dates and have it change color depending on whether it is on schedule or not. Can you help me with this?
Task is set up in B1
It is assigned to a person in B2
Expected completion date in B3
B4 is where the date of completion is entered.
I want B3 to be Green until it gets within 1 week of the Expected completion date
If it is not completed within 1 week of the expected completion date then have it turn Yellow
If it is not completed by the completion date then turn Red.
I have tried multiple ways to get this done but I was hoping that there was a way to have it check B3 if a completed date is entered then turn green or red depending on if the task was completed before the expected due date, or red if not completed by the due date. If this is too tricky, then I can axe it, the first part is the most important.
Please let me know if any additional data is needed.
Thank you,
Shawn
Bookmarks