HOW TO SET UP REMINDERS IN EXCEL?

**janelle** · August 15th 07, 05:30 PM posted to microsoft.public.excel.worksheet.functions

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

**Tevuna** · August 15th 07, 06:34 PM posted to microsoft.public.excel.worksheet.functions

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
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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