You can't highlight just that one word with conditional formatting.
Conditional formatting is applied to the whole cell.

You can highlight all cells with the word allllen in them with something
like this in the conditional formatting for cell A1:
Formula is =NOT(ISERROR(FIND("allllen",A1)))

then copy, edit pastespecial formats to other cells you want to
highlight.

You could conceivably highlight just that one word with some *very* advanced
programming but that is way beyond me.
--
Allllen


"Betty" wrote:

I am trying to use conditional formating to find one word in a column of
cells and highlight just the one word regardless of how many words in that
cell. Has anyone come across this.