#1   Report Post  
Old May 28th 12, 05:43 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Red face Alarms

I am a complete novice and need whayt is probably basic informatio.

I am creating a "live" worksheet where a column of cells contain a critical time.

Is there a way that I can set and alarm ( by making the charecters flash or shange colour) when the time reaches, say, 30 minutes to the time shown in the cell?

All help will be appreciated.

Thanks

  #2   Report Post  
Old May 29th 12, 04:30 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2011
Posts: 621
Default Drop Down Menus

Data ValidationAllowList

In source enter Yes,No

Note: must be comma-delimited with no spaces as I have shown.

Ensure that "in cell dropdown" option is checked.


Gord



On Mon, 28 May 2012 16:38:54 +0000, wobblywheel
wrote:


I am almost a complete novice to Excel and have a couple of quieries. I
will post them separately.

The first is probably a no brainer... HOw do you set drop down menus in
a cell. I just want users of a shared sheet to be able make selectioins
(YES/NO) froma drop down menu.

Thanks

  #3   Report Post  
Old May 29th 12, 10:07 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2012
Posts: 3
Smile

Quote:
Originally Posted by Gord Dibben[_2_] View Post
Data ValidationAllowList

In source enter Yes,No

Note: must be comma-delimited with no spaces as I have shown.

Ensure that "in cell dropdown" option is checked.


Gord



On Mon, 28 May 2012 16:38:54 +0000, wobblywheel
wrote:


I am almost a complete novice to Excel and have a couple of quieries. I
will post them separately.

The first is probably a no brainer... HOw do you set drop down menus in
a cell. I just want users of a shared sheet to be able make selectioins
(YES/NO) froma drop down menu.

Thanks
Thanks Gord. I will try that when next at work in a few days time.


reagards

WW


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 do i set up date alarms/alerts fuchsiahop Excel Discussion (Misc queries) 5 March 7th 08 09:55 PM
Excel Alarms Emma Excel Programming 0 July 25th 07 04:06 PM
Excel alarms duster Excel Programming 1 February 18th 07 01:42 AM
time and alarms Mariner Excel Discussion (Misc queries) 0 July 17th 06 09:54 PM
Spreadsheet Alarms Micrologix Excel Worksheet Functions 1 June 12th 06 11:16 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017