Carl,
John Walkenbach has an example
http://www.j-walk.com/ss/excel/tips/tip87.htm
--
HTH
Bob Phillips
"carl" <[email protected]> wrote in message
news:[email protected]...
> I am monitoring stocks.
>
> I have a column of formulas that returns Yes or No. In almost all cases,
the
> cell value is No. Once every few days, a value can switch to Yes.
>
> Is there a way that I can have the spreadsheet give me an audible alert if
> the value changes to Yes ?
>
> Thank you in advance.
>
Bookmarks