Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-17-2009, 08:17 AM
CGM3 CGM3 is offline Auto date alarm? Windows XP Auto date alarm? 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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto date alarm? Automatic date updates. WLVanS Word 12 01-29-2011 04:01 AM
Automatic Date Change Marusja Word 0 03-04-2009 03:45 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Auto date alarm? Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM
Auto date alarm? Star DP8340 Printer Alarm light on jim2034c Office 2 11-05-2005 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft