In the Conditional Formatting box, put "Formula Is"

=SEARCH(UPPER("repair"),A1,1)<0



HTH,
JP

On Jan 10, 2:38*pm, Soulscream
wrote:
Hi,
I'm trying to highlight a cell using CONDITIONAL FORMATTING if the cell has
the word "Repair" in it anywhere. Example: "123456 - REPAIR" will be in the
cell and the conditional format will recognize the word "Repair" and
Highlight the cell.

Is it possible to do that?

Thanks.