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.

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.

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


"Soulscream" wrote in message ...
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.

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


"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.

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)" wrote:

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


"Soulscream" wrote in message ...
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.

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


"Soulscream" wrote in message ...
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)" wrote:

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


"Soulscream" wrote in message ...
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.