You don't need VBA for this. Conditional formatting will do it. Base
your conditional formula on a COUNTIF statement, highlighting wheere the
COUNTIF gives a value  of >1 when the individual cell is compared to the
whole range  of names.