Hi all,

I have a range of numbers from B2:L2

I then have a page of calculations below doing various sums on this range B4:P100.

What I'm trying to do is simply highlight any cells in the table below that match any of the numbers in range B2:L2.

I tried a conditional formatting formula =COUNTIF(sequence,B4:P100)=0

But this highlights almost every cell..

Any thoughts?

Thanks