Highlight a cell with a specific word in it

[Soulscream]

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.

 

[JP]

In the Conditional Formatting box, put "Formula Is"

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



HTH,
JP

 

[Rick Rothstein \(MVP - VB\)]

Give this conditional format formula a try...

=NOT(ISERROR(SEARCH("repair",D1)))

where you would replace D1 with the active cell in your selection.

Rick

 

[Teethless mama]

=COUNTIF(A1:A1,"*repair*")

 

[Soulscream]

Thanks, Rick. Out of all the responses I got yours was the only one i could
get to work. I was able to actually shorten it to:

=SEARCH("repair",D1)

and this also worked, I had never used the SEARCH function before, you and
the others have been a great help. Thank you so much!

 

[Rick Rothstein \(MVP - VB\)]

Thanks for the feedback. I always thought the Conditional Format formulas had to evaluate to TRUE or FALSE, or at least their numerical equivalents of 0 or 1; but you are right, your reduction of my formula works even though the return condition can be a number greater than 1 or and error condition. Live and learn. By the way, I tried the other two posted formulas and they both worked fine for me. The key was using the active cell in the selection in place of their cell reference to A1.

Rick