Dependant Data Validation - for Whole Column
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?
|