Hi,
I am trying to create a schedule, and want the cell to highlight when there is a duplicate.
My problem is that sometimes the cell has one person, and sometimes it has multiple people, and I want to highlight when a person has been put into more than one task.
e.g.
<tbody>
</tbody>
Here you can see that AS, EK and JS are both in two tasks.
I can get JS to highlight using conditional formatting, as it is an exact duplicate. How can I get the cells that contain AS and EK to highlight as well?
I am trying to create a schedule, and want the cell to highlight when there is a duplicate.
My problem is that sometimes the cell has one person, and sometimes it has multiple people, and I want to highlight when a person has been put into more than one task.
e.g.
Task | Person |
Cleaning | AS + EK |
Filing | JS |
Scanning | AS |
Deliveries | EK + TL |
Phones | JS |
<tbody>
</tbody>
Here you can see that AS, EK and JS are both in two tasks.
I can get JS to highlight using conditional formatting, as it is an exact duplicate. How can I get the cells that contain AS and EK to highlight as well?