How to color the specific cells at once?

[Wordfinder]

Hi,

I have a long table with thousands of cells, some cells should apply background colors, in my case; the cells have a word inside themselves (like Name) and I'd like to give a color to them immediately, rather than select one by one and apply color.