Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How can I set up a reminder alarm system in one of my worksheet?

For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 345
Default How can I set up a reminder alarm system in one of my worksheet?

For a visual reminder how about using conditional formatting ??

"Excel Query" wrote:

For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How can I set up a reminder alarm system in one of my workshee



"Ron@Buy" wrote:

For a visual reminder how about using conditional formatting ??

"Excel Query" wrote:

For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.



How can I use the conditional formatting? Can you explain me step by step
please?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How can I set up a reminder alarm system in one of my worksheet?

if you are using 2007 select cell with birthday select conditional format
from home ribbon, select format only cells that contain, in first selection
box select dates occurring, in the second select today, set format required
and OK
hope this helps
steve

"Excel Query" wrote:

For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How can I set up a reminder alarm system in one of my workshee



"steve h" wrote:

if you are using 2007 select cell with birthday select conditional format
from home ribbon, select format only cells that contain, in first selection
box select dates occurring, in the second select today, set format required
and OK
hope this helps
steve

"Excel Query" wrote:

For example if I have "Birthday" column in one of my worksheet and I want to
set up a reminder for upcoming birthday. How can I do that in Excel.


Thank you. I was able to do that by conditional formatting. thanks again
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
Setting a reminder or alarm in Excel wysi Excel Discussion (Misc queries) 3 May 4th 23 11:43 AM
How do I open an Excel file on XP system, saved on a Vista system JLS7 Excel Discussion (Misc queries) 3 December 2nd 08 04:21 AM
reminder system for various tasks in excel Soon Hui Excel Discussion (Misc queries) 0 August 11th 05 10:02 AM
worksheet protection reminder revor New Users to Excel 3 July 19th 05 11:50 AM
excel causing system to be in low system resource inenewbl Excel Discussion (Misc queries) 0 April 5th 05 04:11 PM


All times are GMT +1. The time now is 04:22 AM.

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"