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.