Data change color when entered 3 times

[Sherie]

I was wondering if there was a way for a number to change color once it has
been entered three times into a spreadsheet. I just need a way to find out
once I enter a number in three times that it will let me know, either a color
change or anything. Thanks.

 

[Luke M]

You could conditionally format a range of cells. Lets say you are entering
numbers in A2:A100. CF formula in cell A2 is:
=COUNTIF($A$2:$A$100,A2)>=3
Pick a format color.

Copy to other cells in range as needed.