Conditional formatting according to number of mentions

Question

Dear Excel community,&nbsp;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.&nbsp;For example:LeaLeaLeaLeaLeaLeaLeaLeaLeaLeaLeaLeaLea&nbsp;Kind regardsLea

sergeibaklan · Answer

leamk&nbsp;
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.

Forum Discussion

Conditional formatting according to number of mentions

1 Reply