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.
