A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

HOW TO SET UP REMINDERS IN EXCEL?



 
 
Thread Tools Display Modes
  #1  
Old August 15th 07, 05:30 PM posted to microsoft.public.excel.worksheet.functions
janelle
external usenet poster
 
Posts: 13
Default HOW TO SET UP REMINDERS IN EXCEL?

I have a huge report with dates and I would like to know if I can have
something to pop up or highlight so it can tell me when something is due, for
example: if I issue a document for a customer in 01/01/06 they need to pay
annually how do I make it that it will remind me that in 01/01/07 I have to
charge this customer.

This is very important because otherwise I will be loosing money because I
can't remember all of them. Please anything will help
Ads
  #2  
Old August 15th 07, 06:34 PM posted to microsoft.public.excel.worksheet.functions
Tevuna
external usenet poster
 
Posts: 136
Default HOW TO SET UP REMINDERS IN EXCEL?

Create a conditional formatting with the formula:
=A1<=TODAY()-365

"Janelle" wrote:

> I have a huge report with dates and I would like to know if I can have
> something to pop up or highlight so it can tell me when something is due, for
> example: if I issue a document for a customer in 01/01/06 they need to pay
> annually how do I make it that it will remind me that in 01/01/07 I have to
> charge this customer.
>
> This is very important because otherwise I will be loosing money because I
> can't remember all of them. Please anything will help

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up Reminders in an excel spreadsheet? ricksta Excel Worksheet Functions 1 March 2nd 06 03:26 PM
create reminders in excel Jan Excel Discussion (Misc queries) 0 February 27th 06 11:53 PM
How do I set up Reminders in an excel spreadsheet? Chilli Mel Excel Worksheet Functions 1 February 21st 06 11:54 PM
Can I set date reminders in MS Excel? do Excel Discussion (Misc queries) 3 October 27th 05 06:04 PM
can i automate task reminders in excel shootist55 Excel Discussion (Misc queries) 0 May 3rd 05 12:37 AM


All times are GMT +1. The time now is 10:40 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.