Condition for repeated Data appearence

Hello everyone, I am seeking your help with this query. I was searching for a way to condition formatting a cell that contains data or even a way of writing down a macro to make a pop-up message or...