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
Bookmarks