Data change color when entered 3 times
 

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.

Data change color when entered 3 times
 

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.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sherie" wrote:

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.