Forum Discussion
Excel Help with filtering data
You have used "" where I had ".
If you use comma as decimal separator, the formula should be
=ISERROR(MATCH("*"&$A2&"*";$B:$B;0))
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.
HansVogelaar - 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))
You have used "" where I had ".
If you use comma as decimal separator, the formula should be
=ISERROR(MATCH("*"&$A2&"*";$B:$B;0))
