Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Hi all I'm running spreadsheet with live data feeds. How can a get excel to alert when when a specified criteria is met? Thanks -G -- gambit ------------------------------------------------------------------------ gambit's Profile: http://www.excelforum.com/member.php...o&userid=37867 View this thread: http://www.excelforum.com/showthread...hreadid=574159 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() you should explain what type of criteria you want to set. gambit Wrote: Hi all I'm running spreadsheet with live data feeds. How can a get excel to alert when when a specified criteria is met? Thanks -G -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574159 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() what I've got is a ratio that is created by two linked feeds. I would like to be alerted by excel when the ratio passes a certain varience. Right now one of the ratios is at 1.60, when it hits say 1 then I would like excel to alert me. -- gambit ------------------------------------------------------------------------ gambit's Profile: http://www.excelforum.com/member.php...o&userid=37867 View this thread: http://www.excelforum.com/showthread...hreadid=574159 |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() this could be achieved by using Data Validation. select cell that contain ratio and go to menu Data Validation under Settings tab look for proper category in Allow list (perhaps you need to select "Decimal") then in Data list select proper category and set limits in input fields (I cannot suggest because I don't know what type of data exactly you need to allow to that cell). In Error Alert tab, set the messege you would like to prompt when your Allow criteria is not met. for more detail about Data Validation visit following link. http://www.contextures.com/xlDataVal01.html gambit Wrote: what I've got is a ratio that is created by two linked feeds. I would like to be alerted by excel when the ratio passes a certain varience. Right now one of the ratios is at 1.60, when it hits say 1 then I would like excel to alert me. -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=574159 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display Alerts | Excel Discussion (Misc queries) | |||
Upcoming Date alerts | Excel Worksheet Functions | |||
How can I set up a milestone report with red/green/amber alerts | Excel Worksheet Functions | |||
Alerts? | New Users to Excel | |||
can you create alerts to notify you when somethng "expires" in a . | Excel Discussion (Misc queries) |