SyntaxFix
Write A Post
Hire A Developer
Questions
Another simpler solution is to use this formula in the conditional formatting (apply to column A):
=COUNTIF(B:B,A1)
Regards!