Hi team! I'm trying to use conditional formatting to compare two lists. List A has duplicates by design; I want to highlight duplicate values in List A that ARE repeated in list B, but NOT highlight duplicate values within duplicated strictly in list A. I can't wrap my head around what question I should be asking the conditional formatter to get that result. Could anyone provide some guidance? In the below example, the goal is to have both Jones, one Smith, and three Youngs highlighted in column A. Both Stevens and Peterson should NOT be highlighted.
Class list_________Active students
Jones__________ Jones
Jones__________ Smith
Stevens_________Young
Stevens
Smith
Peterson
Young
Young
Young
Less important follow-up: If I'm pulling data from a different sheet (like on sheet 1, it will be displaying '=Sheet2!B5', can I get it to bring the formats over onto Sheet 1 from the B5 on Sheet 2?
Bookmarks