I have a XL spread sheet which i have created at work its very simple I only use it to input data for work which receive.

What I need help with is when I enter a address in on a line I want the spread sheet to alert me if i type the same address in again later in the spread sheet.

Help with this would be very much appreciated.

Tony