I have a sheet with a column containing surnames (more than 80 at any given time) and I need to highlight any that are duplicated. So I could normally do this easy enough using conditional formatting. The issue I have is that some cells contain more than one name so for example I might have 'Smith' in cell A2, 'Brown' in cell A3, 'Jones' in cell A4 etc but in cell A5 I could have 'Smith', 'Brown' or even 'Smith', 'Brown', 'Jones'. Conditional formatting does not pick the names as duplicates when entered together in a cell. I guess this is because technically they are not duplicate entries.
Is there any way that conditional formatting can be set do what I need?
Is there any way that conditional formatting can be set do what I need?