Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Setting a reminder or alarm in Excel

Hi

I am trying to set reminders (several reminders into one spread sheet but in
different cells). Am using Excel 2000.

The reminders need to be able to show dates up to one year in advance, and
stay visible when excel is opened (several times).

Have trawled through ms help and cant find anything would be grateful for
any advice

wysi


  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Setting a reminder or alarm in Excel

Hi there!

Setting reminders in Excel can be a useful way to keep track of important dates and events. Here's how you can do it:
  1. First, decide which cells you want to use for your reminders. You can choose any cell or range of cells that you like.
  2. In the cell where you want to set a reminder, type in the date of the event or deadline. For example, if you want to set a reminder for a meeting on June 15th, 2022, you would type "6/15/2022" into the cell.
  3. Next, select the cell where you just entered the date. Then, go to the Home tab in the Excel ribbon and click on the Conditional Formatting button.
  4. In the dropdown menu, select "New Rule".
  5. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
  6. In the formula box, type in the following formula:
    Formula:
    =TODAY()+30A1 
    This formula will highlight any cell where the date is within 30 days of today's date. You can adjust the number of days by changing the "30" to a different number.
  7. Click on the "Format" button to choose how you want the cell to be formatted when the condition is met. For example, you could choose to have the cell turn red and display a message like "Reminder!".
  8. Click "OK" to save the formatting rule.
  9. Repeat these steps for any other cells where you want to set reminders.

Now, whenever you open your Excel spreadsheet, any cells with reminders that are coming up within the next 30 days will be highlighted and formatted according to your chosen settings. You can adjust the formula and formatting as needed to suit your needs.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,355
Default Setting a reminder or alarm in Excel

Without knowing what you want to do it's hard to know what to suggest.

You could use a conditional format to change the background color to
something if the date is within a specific range

Format - Conditional Format
Formula is =A1 - today() < = 30

And set the format to something different.

Cell format would change if cell a1 is 30 or less days after today.

--
HTH,
Barb Reinhardt



"wysi" wrote:

Hi

I am trying to set reminders (several reminders into one spread sheet but in
different cells). Am using Excel 2000.

The reminders need to be able to show dates up to one year in advance, and
stay visible when excel is opened (several times).

Have trawled through ms help and cant find anything would be grateful for
any advice

wysi


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 229
Default Setting a reminder or alarm in Excel

One solution, depending on your situation, might be this. In the top
few rows of your worksheet, type in what the due dates are - titles.
Below them, use the formula similar to those suggested by Barb. Let's
assume the following scenario:

* You have a worksheet called ProjectStartDates
* Column A of ProjectStartDates worksheet contains the project name
* Column B of ProjectStartDates contains the project's start date
* Due date is always 30 days after start date
* You have a data sheet on another worksheet, called ProjectData,
where you want to have the due dates displayed across the top
* Row 1 of ProjectData contains the project's name
* Row 2 of ProjectData needs to have the due date
* ProjectData is a long worksheet

Let's say "ProjectOne" is the name of the project, and it is started
on October 1, 2007. This data is in ProjectStartDates. On
ProjectData worksheet, you have these values (omit double quotation
marks):

A1 = "ProjectOne"
A2 = (formula) "=INDEX(ProjectStartDates!$B:$B,MATCH(A
$1,ProjectStartDates!$A:$A,0))+30"

Enter all your project names in row 1 of ProjectData, and copy over
the formula in A2 - the reference will propagate correctly. Freeze
panes so that the top two rows are always showing, regardless of how
far down you scroll in ProjectData worksheet (it's long, remember) -
select cell A3 on ProjectData, and use Window-Freeze Panes command to
ensure the due dates stay in top row. You may want to unlock the data
cells and protect the workbook, to ensure the formulas remain intact.

Finally, use conditional formatting as described in Barb's post, to
highlight due dates coming up. I would add a second condition to
highlight differently (perhaps in red) for projects that are overdue.

You can obviously expand on this idea by adding flexible due dates,
etc, in a different column. For example, if your column C contains
the number of days until the project's due date from its start date,
the formula will be this (omit double quotation marks):
"=INDEX(ProjectStartDates!$B:$B,MATCH(A$1,ProjectS tartDates!$A:$A,0))
+INDEX(ProjectStartDates!$C:$C,MATCH(A$1,ProjectSt artDates!$A:$A,0))"

Additionally - this was the first thing that came to mind when I saw
the subject of your post - you can use VBA to call up reminders every
so often of projects whose due dates are coming up. This is an option
when you are working in a VBA-friendly environment with macros
enabled. For instance, each time the workbook is opened, you can pop
up a dialog box listing all the project coming up within a certain
period of time, and their due dates. The data for this would, again,
come from the ProjectStartDates worksheet.


On Sep 7, 9:56 am, wysi wrote:
Hi

I am trying to set reminders (several reminders into one spread sheet but in
different cells). Am using Excel 2000.

The reminders need to be able to show dates up to one year in advance, and
stay visible when excel is opened (several times).

Have trawled through ms help and cant find anything would be grateful for
any advice

wysi



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to format alarm in excel cell Surjit Excel Discussion (Misc queries) 0 March 28th 07 02:34 PM
can I set a date alarm in Excel apache_sim Excel Discussion (Misc queries) 1 December 20th 06 05:16 PM
alarm a date in excel to outlook calendar gcarch Excel Discussion (Misc queries) 2 August 28th 06 03:39 PM
Setting a reminder up Shep Excel Worksheet Functions 2 June 23rd 05 10:25 AM
How can a set an alarm in Excel? Laura Excel Discussion (Misc queries) 0 February 16th 05 11:27 PM


All times are GMT +1. The time now is 11:55 PM.

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

About Us

"It's about Microsoft Excel"