Conditional formatting with exception for partial word

[valmir]

Hello everyone:
I have a conditional formatting formula which I need to add an exception for partial text. In this case, in column C, the rule should not apply to any such value where there is a word that includes the partial word "missing", in the matching row in column B
In the attached example, the rule should not apply to cells C13 and C14.
Thanks!

Book7
	A	B	C
1	ACA	Paul	Յ
2	COU	zMissingCOU	Ձ
3	DCH	zMissingDCH	ꞁ
4	DTA	Charles	ꞁ
5	DTA	Matt	Յ
6	DTA	Beverly	ꞁ
7	DVE	Carl	ꞁ
8	DVE	Jo	ꞁ
9	DVE	Loth	Տ
10	FHL	Pedro	ꞁ
11	MAM	zMissingMAM	Ձ
12	NAC	Ted	ꞁ
13	SAG	zMissingSAG	Ч
14	SAS	zMissingSAS	Ч
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C14	Expression	=(C1="Յ")	text	NO
C1:C14	Expression	=(C1="Ч")	text	NO
C1:C14	Expression	=(C1="Տ")	text	NO

 

[Peter_SSs]

Like this?

23 07 23.xlsm
	A	B	C
1	ACA	Paul	Յ
2	COU	zMissingCOU	Ձ
3	DCH	zMissingDCH	ꞁ
4	DTA	Charles	ꞁ
5	DTA	Matt	Յ
6	DTA	Beverly	ꞁ
7	DVE	Carl	ꞁ
8	DVE	Jo	ꞁ
9	DVE	Loth	Տ
10	FHL	Pedro	ꞁ
11	MAM	zMissingMAM	Ձ
12	NAC	Ted	ꞁ
13	SAG	zMissingSAG	Ч
14	SAS	zMissingSAS	Ч
CF Not Missing

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C14	Expression	=AND(OR(C1="Յ",C1="Ч",C1="Տ"),NOT(ISNUMBER(SEARCH("Missing",B1))))	text	NO

 

[valmir]

Like this?

23 07 23.xlsm
	A	B	C
1	ACA	Paul	Յ
2	COU	zMissingCOU	Ձ
3	DCH	zMissingDCH	ꞁ
4	DTA	Charles	ꞁ
5	DTA	Matt	Յ
6	DTA	Beverly	ꞁ
7	DVE	Carl	ꞁ
8	DVE	Jo	ꞁ
9	DVE	Loth	Տ
10	FHL	Pedro	ꞁ
11	MAM	zMissingMAM	Ձ
12	NAC	Ted	ꞁ
13	SAG	zMissingSAG	Ч
14	SAS	zMissingSAS	Ч
CF Not Missing

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C14	Expression	=AND(OR(C1="Յ",C1="Ч",C1="Տ"),NOT(ISNUMBER(SEARCH("Missing",B1))))	text	NO

Perfect! Thanks a lot! I really tried hard (was almost there!) and learning a lot with you guys. Thank you so much!

 

[Peter_SSs]

You're welcome. Glad it helped. Thanks for the follow-up.

This is slightly shorter.

23 07 23.xlsm
	A	B	C
1	ACA	Paul	Յ
2	COU	zMissingCOU	Ձ
3	DCH	zMissingDCH	ꞁ
4	DTA	Charles	ꞁ
5	DTA	Matt	Յ
6	DTA	Beverly	ꞁ
7	DVE	Carl	ꞁ
8	DVE	Jo	ꞁ
9	DVE	Loth	Տ
10	FHL	Pedro	ꞁ
11	MAM	zMissingMAM	Ձ
12	NAC	Ted	ꞁ
13	SAG	zMissingSAG	Ч
14	SAS	zMissingSAS	Ч
CF Not Missing

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C14	Expression	=AND(OR(C1="Յ",C1="Ч",C1="Տ"),ISERR(SEARCH("Missing",B1)))	text	NO