See http://www.contextures.com/xlDataVal02.html

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kumaresh Sierra" wrote in
message ...
Hi,

Am trying to create a Excel template which user can download and fill in

In the first column i have defined data validations to show all the
country
names.

In second column, i have to define the validation based on its adjacent
cell. I want to define it for entire column.

Can any body tell me if this can be accomplished?