I have an external feed that updates every second. However sometimes it loses the connection without me knowing. Is there a way to alert me when this happen? I.e, I need to know when the cell stops updating (it stas frozen on the last value) , preferably having another cell change when that happens (so that I can apply a conditional formatting on it or play a sound).

Many thanks

BC