Forum Discussion
EzzEldean
Nov 10, 2022Copper Contributor
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...
EzzEldean
Nov 10, 2022Copper Contributor
to put it in simple words I want to find a formula or macro to count the occurrences of text that would appear in Cell A5021 and then make a condition that if it occurs 3 times or more within a day or the next three days either give me a pop-up message or highlight the cell as an indicator that the one appeared in cell A5021 is often occurs