Monday, July 28, 2014

yogi_Apply Conditional Formatting To Cells In Column A To Highlight Clients That Are Preferred Clients As Noted In Column B Of Sheet2

                            Google Spreadsheet   Post  #1711
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jul-28-2014
post by Leon Fishman:
Conditional Formatting based on 2 Lists

I was wondering if someone could help me with the following Problem: 

I have 2 lists in Sheets: 

Column A - This has a list of Clients 
Column B - This has a list of PREFERRED Clients

I want to draw attention to values in Column A based on the preset values in column B. 

Is there a single conditional formatting formula that can highlight All values in Column A that are present in Column B as well? 

Thank you :) 
I created a sample sheet here:

Unfortunately the Countif solution did not work :( 

Would conditional formatting still work if the validation data is located on another sheet?