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     www.energyefficientbuild.com.   Jul-28-2014
post by Leon Fishman:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/RKQQbCNNvfI)
Conditional Formatting based on 2 Lists
Hi, 

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: https://docs.google.com/spreadsheets/d/1aoq2g4901BpGD4IdYxXPAeHPETtVfbJ6VxiGZ8nwjUg/edit?usp=sharing

Unfortunately the Countif solution did not work :( 

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