Highlight cells that contains characters repeated x times in the whole sheet

Hi !

I have a big dataset composed of gene ID names (ex. v1g32789). I would like to find a way to highlight the cells that contain an ID that is repeated more than once but less than 4 times in the whole sheet. I don't have an ID of reference, I would like to identify the ones that are present between 2 and 4 times.
I have tried COUNTIF functions as described in other posts such as =COUNTIF($A$2:$E$301,$A1)>2 just to try it out, but I always get an error message and can't figure out why. Plus I need to be able to set an upper limit to the number of duplicates.

Does anyone have an idea on how to achieve that ?

Thanks in advance !

Thank you so much ! That does make a lot of sense ! But sadly I got the same error message than before, "There's a problem with this formula. Not trying to type a formula ? blablabla..."
So frustrating... I really don't know what I'm doing wrong.

I did Home > Styles > Conditional formatting > New Rule > Use a formula to determine which cells to format
...and then entered the formula, that already had the proper range for the sample of my dataset that I wanted to try it on. I set a highlight color under 'Format...', pressed OK and the error message popped up.

Is there anything obvious that I am doing wrong ?

Hi again, I found the problem ! My separator (...I hope that's the right word) didn't match your formula I changed it from ';' to ',' and now it works just fine. Dammit Norway.

Thank you so much, you made my day !

Yeah actually another problem appeared :/ The formula seems to highlight only whole rows. Some of the cells that are highlighted contain indeed an ID that is repeated 2 to 4 times in the worksheet, but not all duplicates are highlighted. And some of the highlighted cells contain ID that are not repeated, it looks like they were only highlighted because they are on the same row as repeated ones...

So in the end it does not work at all for my purpose I got excited a bit too fast ! Any idea of what changes would help ?

IT WORKS

YAASS

Thanks !!