Highlight matches from another sheet

[SaraWitch]

Hello peeps.

I have two sheets that are both filtered which I want to compare to see what's missing.

In Sheet2, I have conditionally formatted column BB to match with column A in Sheet1 (and applied to =$B:$B):

=NOT(ISERROR(MATCH(BB6,Sheet1!$A:$A,0)))

But there are matches that are not highlighting in Sheet2.

I can't upload the workbook as it contains sensitive information, but any help would be appreciated if anything is jumping out to anyone...

Ta muchly!

 

[Anfinsen]

Since you can't post the sheet, we can't help much. I do have one suggestion, add a trim to your match formula, and see i that helps. Trim both the lookup value and the matching value, in the formula.

 

[Fluff]

If you have applied the CF to the whole column, you need to use BB1 not BB6 as it must refer to the 1st row in the applies to range.

 

[SaraWitch]

Of course! It's always so simple when I'm given the answer! Thank you so much, @Fluff

 

[Fluff]

You're welcome & thanks for the feedback.