Use Conditional Formatting to to Highlight Cells with Specific text and IF formula condition

[mminchev]

I have 3 cells that I am looking at:

Contact Name​	Name Word Count​	Name Fix​
John John Doe	3	John Doe
Bear Bear Joe	3	Bear Joe

What I need is to run Conditional Formatting formula to highlight the CONTACT NAME column if the number in the NAME WORD COUNT column is equal to 3 and if the text in the NAME FIX column is contained in the CONTACT NAME column. I really appreciate any help on this, its one of those that we all get stuck on sometimes, but I am sure has a simple solution.

 

[GraH]

Book1
	A	B	C
1	Contact Name	Name Word Count	Name Fix
2	John John Doe	3	John Doe
3	Bear Bear Joe	3	Bear Joe
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A3	Expression	=AND($B2=3;ISNUMBER(FIND($C2;$A2)))	text	NO

Note the formula is case sensitive. If that's not required, this can be used instead

=AND($B2=3;ISNUMBER(SEARCH($C2;$A2)))

 

[mminchev]

Book1
	A	B	C
1	Contact Name	Name Word Count	Name Fix
2	John John Doe	3	John Doe
3	Bear Bear Joe	3	Bear Joe
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A3	Expression	=AND($B2=3;ISNUMBER(FIND($C2;$A2)))	text	NO

Note the formula is case sensitive. If that's not required, this can be used instead

=AND($B2=3;ISNUMBER(SEARCH($C2;$A2)))

Worked great, thank you for your help!

 

[GraH]

Most welcome. Thanks for the feedback.