Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deadline Reminder
I would like a program to run on opening a worksheet that will remind me of a
deadline two days before it is due. I would like the reminder to run on any cell that contains a certain character, such as %. Is this possible? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deadline Reminder
Hello,
I suggest to apply a conditional format: http://www.mvps.org/dmcritchie/excel/condfmt.htm Look for: "Formula is: (within next 8 days) =AND($B1TODAY(),$B1<TODAY()+8)" Regards, Bernd |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deadline Reminder
Thanks for your response, but the page you referred to provide me with any
new information; I would need to know how to launch msg.box when a date is found on the sheet that is two days away. Thanks for your continued help. Danny "Bernd" wrote: Hello, I suggest to apply a conditional format: http://www.mvps.org/dmcritchie/excel/condfmt.htm Look for: "Formula is: (within next 8 days) =AND($B1TODAY(),$B1<TODAY()+8)" Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please help...I am at work and have a 3pm PST deadline... | Excel Discussion (Misc queries) | |||
PLEASE help - Fast approaching deadline | Excel Programming | |||
Deadline Notice | Excel Worksheet Functions | |||
Active Deadline | Excel Discussion (Misc queries) | |||
missing deadline | Excel Worksheet Functions |