| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
HIGHLIGHT A DATE 10 DAYS BEFORE IT IS PAST DUE
Hi,
Try Sub Past_Due() Dim fd As Date fd = Date If fd = Cells(1, 1).Value + 20 Then MsgBox "10 day's before past due" End If End Sub "cookie04" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have excel highlight days before & after a date on a cale | Excel Worksheet Functions | |||
| Rolling date looking 30 Days past | Excel Worksheet Functions | |||
| how do i highlight a date that is 4+ days old in excel? | Excel Worksheet Functions | |||
| flag date within a cell after 15 days have past? | Excel Worksheet Functions | |||
| Highlight past & future events | Excel Discussion (Misc queries) | |||
Hybrid Mode
