alerts
 

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

alerts
 

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

alerts
 

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

alerts
 

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