Need Formula Help

[austenr]

I am trying to use this formula in conditional formatting to highlight every occurance of B not found in A. I think I am missing a ) or something:


=(COUNTIF($A:$A,B1)=0*(B1<>"")"

any help is appreciated. Thanks

[malik641]

You BARELY messed that one up...


=(COUNTIF($A:$A,B1)=0*(B1<>""))

That should do it!
Let me know :thumb