Forum Discussion
Conditional formatting according to number of mentions
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...
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.