Conditional formatting according to number of mentions

[leamk]

Dear Excel community,

I have a table with several names in it and every name can occur multiple times. I want each name to be marked red in the background, if it's mentioned 10 times or more. But not every mention of the name should be red. Just the 11th, 12th etc. mention. Is that possible? I would appreciate your help very much.

For example:

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Lea

Kind regards

Lea

[#2]

@leamk 

You may apply conditional formatting rule with formula like here

just be careful with starting cell as well as with using of absolute and relative references.