Highlighting duplicate names in multiple cells

[Garden Utopia Productions]

Hi all,

I am trying to find a way to highlight cells that contain duplicate names using conditional formatting or VBA. There are a number of people attending a workshop that has several sessions each hour throughout the day. The idea is for this for point out if a person has been entered to attend more than one session that occurs at the same time. This way the sessions can be reorganized to allow the person to attend the sessions they need to be involved with. The caveat is that there can be upwards of 50 names listed in the same Attendees cell. For example in the table below, Name 1 is listed in 3 sessions - so those cells would be highlighted.

8:00 AM	Attendees
Session 1	Name 1, Name 2, Name 3
Session 2	Name 1, Name 4, Name 5, Name 6
Session 3	Name 7, Name 8
Session 4	Name1, Name 9
Session 5	Name 10, Name 11

To take this a step further, if it's possible to highlight a specific name, that would be even better!


I know this can be done manually by searching (ctrl+f) a person's name, but I want this to be an automated process. Thanks in advance!

 

[arthurbr]

Why not apply Data - Text to columns - to col B using the comma as delimiter
You then get multiple columns each with one participant
Now use =COUNTIF($B$2:$X$100,B2) as CF and format as required