Thread: [Solved] Auto date alarm?
View Single Post
 
Old 11-17-2009, 08:17 AM
CGM3 CGM3 is offline Windows XP Office 2003
Advanced Beginner
 
Join Date: Oct 2009
Posts: 38
CGM3 is on a distinguished road
Default

One solution would be to put something like this formula in a cell adjacent (on the same row) to the "action taken" cell (assuming here that we're on the second row and the "action taken" cell is in column B):

Code:
=IF(NOW()-B2<30,"","Thirty Days Have Passed!")
Of course, you can change the number of days and the message, but essentially whenever the given number of days have passed, the message will be displayed. You can format the cell to display in red to make it more noticeable.

An alternate method would be to use Conditional Formatting on the "action taken" cells so that if the value of the cell is less than:

Code:
(Now()+30)
--the text of the action cell displays as red (or some other color, or a distinctive font, or whatever).
Reply With Quote