Until somebody suggests something a little more polished, use a formula like:

=LEN(E4)=LEN(SUBSTITUTE(E4,"Smith",""))


"KarenH" wrote:


Is it possible to implement conditional formatting based on text contained
in a cell? Example, user wants to be able to highlight all the cells in a
spreadsheet for a given entity (which will change all the time) so I'm
looking for something like "cell contains xyz" -- but as far as I can tell,
it works only with numeric values.

Am I trying to do something that is impossible?

Thanks in advance.