Hello everyone.
I'm new here on this forums. Normally when I don't know how to do certain stuff, I just search Google. But this time, I think it needs a larger explanation for my problem.
So let's say I have this column that I constantly fill in with data (This is Column A):
apple
banana
orange
apple
grapes
kiwi
Now, my next entry is apple. Now I want all the cells (and some cells on their rows as well) to have a change in fill color or something whenever an entry appears THRICE. Something that will highlight it.
In programming terms, this will mean that everytime I enter another value for Column A, it will have to crosscheck all the values of the entire Column A and check if my current entry appears three times or more. Then it uses some sort of conditional formatting (?) to highlight all entries with "apple" in Column A.
I don't know how to do this. Please help.
Bookmarks