Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question on conditional formatting & email macro
Hi,
I am working on a spreadsheet that is used to track project progress. A start date is manually entered and the spreadsheet automatically fills in the expected start and finish dates for the various steps in the project. I need a cell (that contains a date) to turn orange when the date is 10 days or less from todays date. I already have it conditionally formatted to turn red when todays date = the cell date. Also, I have been trying to figure out how to make the excel email the responsible project leader when the due date is less than 5 days from todays date but I have had difficulty figuring out the Ron de Bruin macro. I'm running Excel 2003 SP2. Any help is appreciated. Thanks Max |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with a prompt and new email message | Excel Discussion (Misc queries) | |||
Conditional Formatting Question | Excel Worksheet Functions | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Conditional formatting - copy & paste to an email | Excel Discussion (Misc queries) | |||
Excel Macro Question about Conditional Formatting | New Users to Excel |