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