| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Overdue function, Macro, or VBS
I have a spreadsheet that have two columns: 1. Task 2. Due date
I wanted to have an easy indication to see what tasks (rows) are overdued. To do so I created two more columns: 3. Today Date 4. Overdue? In column #3 I typed today() in all rows. In Column 4 I typed: =If (X3X2, "Overdue",""). In this case whenever I have task which is overdue, automatically field 4 will read "Overdue" Can I make a Macro or VB Script that in addition to the above the whole row will be highlighted (let's say green). Thanks, galsaba ) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to alter the date within a macro | Excel Discussion (Misc queries) | |||
| Today() or Date() function help | Excel Discussion (Misc queries) | |||
| Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) | |||
| How do I use the IF function to calculate date | Excel Discussion (Misc queries) | |||
| Date and Time Macro | Excel Discussion (Misc queries) | |||
Threaded Mode
