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. |
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 |
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 |
All times are GMT +1. The time now is 11:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com