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.
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