Play a sound when a new high is detected

[CDandVinyl]

I'm trying to play a sound if any cell in the range N3:N300 changes to the word 'Highest'.

The cells in the range contain formulas and only show the word 'Highest' as a result of a MAX calculation on range P3:P300.

Effectively , if the cell in N3:N300 changes to the new 'Highest' , then it should play the sound. It would only play when there is a change in the highest.

For example if the highest cell is N145 and there is no change then no sound need be played. If it changes to say N55 then a sound would play.

Can someone offer some event code to satisfy this?


Grateful for any advice.