Can i get an alert when real time data changes?

[Guest]

I import real time data (stock quotes) from outside sources (Bloomberg, etc).
I have formulas that calculate changes and ratios throughout the day. I
want to be notified (through a popup message, or email) when these values
reach a certain range. Is that possible

 

[Tushar Mehta]

Pop-up or email (or sound) would require programmatic support.
Depending on your comfort level with VBA, check out the worksheet
object's Calculate (or Change) event.

On the other hand, conditional formatting would not but all it would do
is change the format of specified cells.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Dave Peterson]

Take a look at John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip87.htm

But John has a note at how irritating this could be.