Conditional format row based on cell contents

[rbobcat1]

What formula would I use to highlight only those rows that contain abc?
I have tried =$c2=”abc”
I also tried Search and Find but they didn’t work either.

column a	column b	column c
FALSE​	TRUE​	abc.def.ghi.jkl
FALSE​	TRUE​	123.456.789.012
FALSE​	TRUE​	xyz.abc.def.ghi
FALSE​	TRUE​	345.123.456.789
FALSE​	TRUE​	uvw.xyz.abc.def
FALSE​	TRUE​	890.345.123.456

 

[rbobcat1]

uploaded file

I even tried wildcards

 

[Fluff13]

The cell in the formula should match the first row in the Refers to range, so change it from $C1 to $C2

 

[Juniad]

Try this in conditional new rule.
=SEARCH("abc",$C1)>0

 

[Fluff13]

@Juniad
There is no need for the >0 in the formula

 

[Juniad]

Without making True False arguments i won't work. So either use >0 or Isnumber()

 

[Fluff13]

Works for me just by changing the range in the formula from $C1 to $C2
if the formula returns a number it's treated as TRUE and an error is treated as FALSE

 

[rbobcat1]

wow i cannot believe i missed that. i guess i was messing with it so much i messed up.

How about another one, what if there is another criteria it must meet?

for instance; if column b =this and column c has 123
I have notice when trying IF and =TEXT it kind of turn numbers in to garbage (see a13)

 

[rbobcat1]

I think i just answered my own question

=AND(OR($B2="This",OR($C2="123")))

Is this the best formula?

 

[Fluff13]

If you mean col C contains 123, try
=AND($B2="This",SEARCH(123,$C2))