Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Past Due/Completed on time date formula
I am pretty familiar with Excel, but just learning formulas...
I have two columns I am working with for this question, a due date and completed date. I used the formula =A1<=today() to highlight a "past due" date red. I was wondering if in my completed date column I could enter a formula that would highlght a date Red if it was past the date, or blue if it is bofore the due date. Also, will this update as I work with it, or only as I enter in cells? Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
oldest date not completed | Excel Worksheet Functions | |||
Using date and time of past crimes to project the next occurance | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Number of tasks completed in a specific time frame | Excel Discussion (Misc queries) | |||
When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions |