Conditional Formating from a Data Validation List

[jfayer]

Scenario:

Sheet 1;Column C and Column D:

I have user typed "Customer Names" in Column C. I have a drop down list in Column D, which allows user to designate the customers as a "Partner" or a "Non-Partner"

I have a color coded conditional formatting on Sheet 1 working properly based on "Partner"(green) or "No Partner."(red)

Example
ABC Co. - Partner (results in Green cell )
XYZ Co - Non-Partner (results in Red Cell)

Sheet 2 ( Issues lies here)

Columns G-J contains a drop down list generated from the Customer List in Sheet 1 (Sheet 1Column C) This is working properly

What I want:

On Sheet 2 when the user selects a customer from the drop down list I want the same color coded conditional formatting based on "partner vs non-partner" from Sheet1 Column D.

Thank you for any help.

 

[jfayer]

Bump...anybody have any suggestions...or is my explanation poor?

 

[bschwartz]

Try this conditional formatting rule in Column G on sheet 2 (assumes your data starts from G2):

Green rule: =VLOOKUP(G2,Sheet1!C:D,2,0)="Partner"

Red rule: =VLOOKUP(G2,Sheet1!C:D,2,0)="No Partner"

 

[jfayer]

Ben, thank you. That worked wonderfully

 

[bschwartz]

You're most welcome.