I have cells in the range of B1:V70, some with text, some blank. I want to color-code the names in those cells, based on the name alone. The project started small, so I had each person with a rule set for them:
Cell value equal to ="John Smith" and applied it to =$B$1:$V$70 and format set to red text. As the project has grown, I now have 12 people that need to be red, 38 blue, 25 green, etc., yet I still have one rule for each person.

I want to eliminate as many of those rules as possible, so the plan was to eliminate them and replace them with something like:
Formula: =OR("John Smith","Mary Jackson","Bob Miller") apply it to =$B$1:$V$70 and format set to red text.

However, that didn't work - all the names show up in black text. What do I need to change to get this to work?