Data change color when entered 3 times

S

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.
 
L

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top