| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight a cell when a date is overdue?
Hi,
I was wondering if anyone could help provide the formula required to highlight a cell when a return date is overdue. Column L is the date sent and column M is the date returned. I want to highlight the cells in column L if the corresponding cell in column M is still blank after 14 days. Thanking you in advance B. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating overdue date fields | Excel Worksheet Functions | |||
| highlight cell with colour if date overdue | New Users to Excel | |||
| how do I calculate 30, 60 90 days overdue from date invoiced | Excel Discussion (Misc queries) | |||
| need an overdue date to highlight | Excel Discussion (Misc queries) | |||
| Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) | |||
Hybrid Mode
