Conditional formatting cells in column B based off of values in column A

[HeRoseInThree]

I am trying to highlight column B based off of values in column A.

If A has the word parts in it, then I want B to change. I Googled it and seen several examples, I just can't find a way that works for me.

N&I - BLANK - repair bill - ESTIMATE.xlsx
	A	B
19	tow	1
20	storage	2
21	ship	3
22	labor	4
23	itow	5
24	gas	6
25	inspect	7
26	sf	8
27	af	9
28	lop	10
29	dot	11
30	scene	12
31	wc	13
32	fea	14
33	report	15
34	parts
35	prop
36	bodyp
37	bodyl
38		20
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B34:B37	Cell Value	contains "parts"	text	NO
A19:A38	Cell Value	="bodyl"	text	NO
A19:A40	Cell Value	="bodyp"	text	NO
A19:A40	Cell Value	="parts"	text	NO
A19:A40	Cell Value	="prop"	text	NO
A19:A40	Cell Value	duplicates	text	NO

 

[Fluff]

You can use a formula

+Fluff 1.xlsm
	A	B
19	tow	1
20	storage	2
21	ship	3
22	labor	4
23	itow	5
24	gas	6
25	inspect	7
26	sf	8
27	af	9
28	lop	10
29	dot	11
30	scene	12
31	wc	13
32	fea	14
33	report	15
34	parts
35	prop
36	bodyp
37	bodyl
38		20
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B19:B38	Expression	=ISNUMBER(SEARCH("parts",A19))	text	NO

 

[HeRoseInThree]

Thank you so much!!!

 

[Fluff]

You're welcome & thanks for the feedback.