Excel Notification
Hi There,
I have four columns in my Checklist workbook Excel among many more, with formulas associated with it.
The columns are
PreAnaerobic PreAerobic PostAnaerobic PostAerobic
Positive Negative Positive Positive
Positive Positve Positive Pending
So what I want excel to do with these columns is, the date from when I enter , positive ,negative or pending after 10 days it has to notify me that the data is pending in a certain column.
How is that possible? Hope I have not confused everyone..:)
Please help.
| Attachment | Size |
|---|---|
| Processing database14June2012.xlsx | 37.22 KB |
Excel Notification
One approach is do the following:
Add a column with a formula that takes the enter data and adds 10 days to it (it can be either calendar or workdays).
Then add a second column called NOTIFICATION, and enter a formula that will input in a message if todays date equals the due date. The notification cell can also be formatted to turn a color (like RED) for easy visibility
If you need help let me know
Marty