Highlighting a combination of different product types

[DarkChaosDS]

Hello, I have a spreadsheet with 3 different product types. Product A, Product B and Combo. Customers can have multiple lines of the same or different products. (i.e Customer can have 5 entries of Product A with 2 entries of Combo for example)

I want to highlight all the customers who have Combo product or have a Combo along with Product A in yellow. I have currently been doing this manually by filtering the data to only show Combo type , highlighting all the combo products yellow, and then removing the filter. I then scan the list manually and look for the highlighted combo lines and highlight all the customer's products.

Is there a formula or filter I can use for this situation? I was thinking along the lines of a formula that can recognize a yellow highlight, and highlight all rows with the same name or customer address.

Example of how my spreadsheet looks

Name	Address	Product Type	Cost
Adam	1 Main Street	Product A	15
Adam	1 Main Street	Product B	20
Steve	1 Avenue Rd	Combo	15
Kate	2 Highway St	Combo	15
Kate	2 Highway St	Product A	20
Kate	2 Highway St	Product A	20
Kate	2 Highway St	Product A	15

So in this instance I would want every row for Kate to be highlighted Yellow along with Steve.

Thanks!

 

[Fluff]

Hi & welcome to MrExcel.
How about

+Fluff 1.xlsm
	A	B	C	D
1	Name	Address	Product Type	Cost
2	Adam	1 Main Street	Product A	15
3	Adam	1 Main Street	Product B	20
4	Steve	1 Avenue Rd	Combo	15
5	Kate	2 Highway St	Combo	15
6	Kate	2 Highway St	Product A	20
7	Kate	2 Highway St	Product A	20
8	Kate	2 Highway St	Product A	15
9
10
Master

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:D20	Expression	=COUNTIFS($A$2:$A$20,$A2,$C$2:$C$20,"Combo")>0	text	NO

 

[DarkChaosDS]

Thanks for your reply and the welcome. This works well.

 

[Fluff]

Glad to help & thanks for the feedback.