I'm working on an Excel Spreadsheet that maps out due dates.
You enter the date a document was submitted and it fills out the course that a user has to follow for the remaining timeline of that document.
With the due dates, I want to color-code warning dates, and past-due dates.
01/01/2012 - Document submitted
Excel will show the submission and the due date
01/10/2012 - Follow-Up due
So let's say the C5 is the user input box for the date.
C11 is the box that declares the due date for follow-up.
C12 is a reference box as to the "status" of it's follow up.
I want to box C12 change colors accordingly;
Light Yellow - 5 to 1 days before due
Yellow (darker) - on due date
Red - any date after due
I used the following conditional formats:
Yellow (darker) =C11=TODAY()
These both worked out fine for me and do what I wanted.
I am lost on the light yellow variation though.
None of the formulas I tried for the TODAY() function and the date range have worked.
Any help if appreciated, Thanks.