Forum Discussion

Copper Contributor

Aug 15, 2023

Solved

Using conditional formatting to highlight a large range based on a smaller range w/specific text

I am trying to filter through 35,000 rows of names to find matching values from another column. In the image below, I wanted to use conditional formatting on Column B in order to find cells that have...

excel

Formulas and Functions

mtarler
Aug 15, 2023
BLMAN01 something like this should work:
=MAX(--ISNUMBER(SEARCH(LEFT($M$4:$M$100,9),B2)))

mtarler

Silver Contributor

Aug 15, 2023

BLMAN01 something like this should work:

=MAX(--ISNUMBER(SEARCH(LEFT($M$4:$M$100,9),B2)))

BLMAN01

Copper Contributor

Aug 15, 2023

mtarler worked like a charm! Thank you!