Help with Conditional Formatting to highlight entire row

[kyber]

Hello,
I need to have a conditional formatting in place that it highlights everything in the entire row if column C contains a certain word. For some reason "*"Invalid"*" doesn't cut it. If I use the "Text that Contains" feature it only highlights the one cell.

Also, is it possible to establish multiple categories/criteria for the same conditional formatting in 1 single rule if the desired conditional formatting is the same?

[AliGW]

Better to attach a sample workbook as outlined in the first yellow banner at the top of the page.

[kyber]

Got it. Done.

[AliGW]

You haven’t mocked up manually what you want to see. Which cells should be highlighted?

[kyber]

Understood. Here it is.

[AliGW]

Use this CF formula rule for A2:

=ISERROR(SEARCH("invalid",$C2))=FALSE()

Choose your formatting.

Set the Applies To box to $A$2:$C$4.

[kyber]

Stupendous, thank you so much.

Is it possible to establish the same same but with multiple criteria words? For example Invalid and Compliance?

Sorry in advance that this example was not included in my sample sheet.

[AliGW]

You could try this:

=OR(ISERROR(SEARCH("invalid",$C2))=FALSE(),ISERROR(SEARCH("compliance",$C2))=FALSE())

UNTESTED

[kyber]

Worked out great, thank you so much!

[AliGW]

Thanks for the rep.

[kyber]

Question, why is that when I added a 3rd condition to the formula it didn't work and sometimes gave me an error message? I took your example and added:

=OR(ISERROR(SEARCH("invalid",$C2))=FALSE(),ISERROR(SEARCH("compliance",$C2))=FALSE()),ISERROR(SEARCH("broken",$C2))=FALSE())

Let me know if you want me to upload a sheet.

[kyber]

This is the error I keep getting when I edit the formula

[protonLeah]

Please Login or Register  to view this content.

[kyber]

Not sure what you did that I failed to do, but it works. Thank you!

Where did I go wrong?

[protonLeah]

=OR(ISERROR(SEARCH("invalid",$C2))=FALSE(),ISERROR(SEARCH("compliance",$C2))=FALSE() )
,ISERROR(SEARCH("broken",$C2))=FALSE())
-----------------
as you wrote it, the third term was outside the or function.

[kyber]

Of course, of course. The smallest detail. Thank you so much!

[protonLeah]

You're welcome