I have dynamic data that is automatically updated by a live feed. It updates cells m3:m32.
I currently have a code that plays a sound whenever a value in any of the cells is greater than a certain threshold and another code that plays when any of the cells goes below a certain threshold.
The problem is the sound continues to play each time the live feed is updated and the cell condition is correct.
I want the sound to play once for example when a cell value first goes less than 4, but then dont play again if it continues to be under 4. However, if a new cells value goes to less than 4, I want the sound to play.
The problem at the moment is my code limits the sound to play once but it applies to the total cell range not the individual cells so if a 2nd cell's value drops below 4 it wont play.
I currently have a code that plays a sound whenever a value in any of the cells is greater than a certain threshold and another code that plays when any of the cells goes below a certain threshold.
The problem is the sound continues to play each time the live feed is updated and the cell condition is correct.
I want the sound to play once for example when a cell value first goes less than 4, but then dont play again if it continues to be under 4. However, if a new cells value goes to less than 4, I want the sound to play.
The problem at the moment is my code limits the sound to play once but it applies to the total cell range not the individual cells so if a 2nd cell's value drops below 4 it wont play.