I need to create a conditional alarm ( sound or notification box - pop-up message or any )

To make them flash the background of the cell has to be formatted. This will override the color formatting you already have (you have a lot of formatting). Also, you have merged cells which makes highlighting entire rows difficult.