Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can Excel send alerts when due dates are not met?
If I want to know if a something has not met the due date set in my
spreadsheet, can Excel send me an alert in some way? Or can the cell become flagged when the date is not met so it can be easily detected? |
#2
|
|||
|
|||
One way to do it would be to use Conditional Formatting. Let's say the due
dates are all in Column A: - Select all the cells that you would like to apply the Conditional Formatting to. - FormatConditional Formatting - Assuming there's no conditional formats already, under condition 1, choose from the drop down menu "Formula Is" rather than "Cell Value Is". - Enter this formula in the adjacent box: =A1-TODAY()<0 - Select the formatting you want. One thing to note is TODAY() is a volatile function. It's not a good idea to have too many volatile functions in your worksheet. So if you have a lot of dates, it is better to enter in one of the blank cells, say F1, the formula = TODAY(). For your conditional formatting, you then enter this formula instead: =A1-$F$1<0 "gmatimes4" wrote in message ... If I want to know if a something has not met the due date set in my spreadsheet, can Excel send me an alert in some way? Or can the cell become flagged when the date is not met so it can be easily detected? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I link purchase order dates from one excel workbook to ano. | Excel Worksheet Functions | |||
Getting Excel on new computer to show dates like on old | Excel Discussion (Misc queries) | |||
how do I add a signature to an e-mail from excel 'send to' | Excel Discussion (Misc queries) | |||
Excel 2003 dates | Excel Discussion (Misc queries) | |||
How to Create an Excel Macro to send a meeting request. | Excel Discussion (Misc queries) |