Solved Today Function and Date Range in Excel

July 17, 2012 at 10:54:43
Specs: Windows XP
Hey guys,

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:
Red =C11<TODAY()
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.

See More: Today Function and Date Range in Excel

Report •

July 17, 2012 at 11:26:30
✔ Best Answer

Report •

July 17, 2012 at 11:54:31
That did exactly what I was looking for, thanks a lot!

Report •

Related Solutions

Ask Question