0

Col A2:C15 contain a list of names. I need to enter those names in various combinations into one of 15 other cells on formatted like:

H3 = John, Steve, Bob, Dan

Is there a way to use conditional formatting to highlight the cells in A2:C15 based on the list of the names in other cells? I can get it to highlight a cell with just one name, but nothing after the "," is formatted.

0

=ARRAYFORMULA(REGEXMATCH(A1,TEXTJOIN("|",1,TRIM(SPLIT($H$3, ",")))))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.