Warning when i type the same name in the same column or row

Hi,

attached there is problem i need to solve.
when i type the same name in the same column or row i need a msg box that the name alreafy exists.
alternative instead of msg box we can highlight the cell or change the back color of the cell

Thanks in advance

Antonis