I'm trying to set up a spreadsheet and capture a change in the (Contents or calculated Value) of a cell. One of the cell's formulas is as follows:=IF(AND(B11<=D11,B11>0),"BUY","").
My problem is that I want to have an audible beep sound when I get "BUY" signal. The change event only fires when the cell value is changed by keyboard input, not if it changes via formula.I can't reference Column B or D with the change event as those numbers are changing constantly.
Thanks so much!