Excel Help with filtering data

[Shelfrich]

I need assistance with a spreadsheet where I want to compare 2 columns. Column A contains cells where each cell contains only 1 physician's name. Column B contains cells where there are multiple physicians' names. Is there a way to designate the rows where Column A (physician) is not in Column B (multiple physicians)?

Thank you so much!

[#2]

@Shelfrich 

Select the range in column A with names. I'll assume that A2 is the active cell in the selection.

On the Home tab of the ribbon, select Conditional Formatting > New Rule...

Select 'Use a formula to determine which cells to format'.

Enter the formula =ISERROR(MATCH("*"&$A2&"*",$B:$B,0))

Click Format...

Activate the Fill tab.

Select a color to highlight the cells.

Click OK, then click OK again.

[#3]

@Hans Vogelaar -  I am receiving a error message that says "There's is a problem with this formula. Not tring to type a formula? When the first character is an equal= or minus -sign, Excel thinks it is a formula." This is what I typed in:

=ISERROR(MATCH(""*""&$A2&""*"",$B:$B,0))

[#4 · Accepted solution]

@Shelfrich 

You have used "" where I had ".

If you use comma as decimal separator, the formula should be

=ISERROR(MATCH("*"&$A2&"*";$B:$B;0))