Take a look at http://www.contextures.com/xlDataVal03.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Gary C" <Gary wrote in message
...
I have a sheet for a sports team. When making the lineup I select the
players from a drop down list.
How do I format the cell to not repeat a name that is selected in a cell?