I am having trouble with conditional highlighting.
Scenario: I have a list of ID's (A1) each correspond to one Name (B2). For each ID there may be one or more Codes (C2) corresponding to it. Thus, I would like to highlight each ID that has more than one Code listed. In the example snap shot I provided, I would have highlighted Row 5 or cell A5 becuase it has C5, C9, C13, and C24 associated to it. Once I've highlighted row 5 or cell A5 I can filter by cell color to evaluate the values in column E and F.
Please see updated image for reference, the cells are not merged.
ID Name Code Name # Alpha
1234 Doe, Jane WORK WORK 1 5017 ABC
11147 DEF
5678 Doe, John OUT OUT 1 5014 JKL
5017 MNO
11147 PQRS
16000 TUV
OPEN OPEN 1 5010 DEZ
5017 ABC
11123 CCC
16000 TUV
CLOSED CLOSED 1 2665 BB
5003 DD
5004 EE
5005 FF
5006 GG
5007 HH
5008 II
5009 JJ
11052 JQR
11121 RQJ
11124 GIH
LIFT LIFT 1 5003 DD
5004 EE
5005 FF
5006 GG
5007 HH
5008 II
5009 JJ
11052 JQR
11121 RQJ
11124 GIH
15022 BLUE
8876 Blue, Jean WORK WORK 1 5017 ABC
11147 DEF
16000 GHI