Filter or Highlight Cells From 2 Columns

[mayers]

Essentially I need to filter or highlight all cells in column A that contain any of the state names in Column B. How is this done?

 

[Momentman]

You can use conditional formatting
1. Highlight the cells in column A
2. Go to conditional formatting and choose to use a formula to format the cells
3. Type in this formula
=SUM(IFERROR(SEARCH($B$1:$B$3,A1),0))>0

You should get an output like this

Excel 2010
	A	B
1	home is	alabama
2	home sweet home	chicago
3	home in alabama	new york
4	here is my home
5	I want to go home
6	sweet home chicago
Sheet1

 

[mayers]

Thanks!