Conditional Formatting for many different values

Question

I've been trying to create a conditional format formula that looks in a column and finds a series of names and colors them the same color. I want to get this done with one formula instead of a bunch of formulae.

I have tried INDIRECT, VLOOKUP and to work with a statement from How to fill cells based on complicated formula?. I'd like something like this: Excel dynamic conditional formatting based on cell version 2 but am having trouble converting it to text instead of date.

Answer 1

If you have two lists of names, say in ColumnA and ColumnI, and wish to highlight those in A that feature in I please select columnA and try applying a Conditional Formatting formula rule of:

  =MATCH(A1,I:I,0)>0