Conditional Format Based on a Defined Range

Originally Posted by Ace_XL

I changed the formula to
=NOT(ISNUMBER(MATCH(F6,PrimaryVendor,0))) to find exact matches

As far as I've been able to 'stress test', this seems to be the solution. Thanks for the time and well-thought solution Ace!

Originally Posted by Ace_XL

Note the relative reference to F6, this will change to F7, F8 and so on for the next rows.

And like I said, I haven't found any issues, but are the references changing in the background? Because in the conditional formatting it says F6 for all of the cells.

Thanks again!