Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A colleague just came to ask me re this and I'm not advanced enough in my
vb skills at all, but thought I'd find out for her anyway. She'll have a column showing a date. In another column, it'll have a target date. I'm guessing that in a third column, she could have a formula so that all rows that have the one date "overdue", i.e., that is going past that due date, will show something. Either text saying "overdue", or even better, "1 day(s) overdue", the "1" being replaced by however many days they are past due. Is this do-able? What would be best approach, does anyone feel? Thank you! :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
conditional formatting for "overdue" status | Excel Discussion (Misc queries) | |||
How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
=IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) | |||
How do I split "A1B2" into "A1" and "B2" using text to column fun. | Excel Programming |