The validation doesn't work that way....
to apply the validation to the entire column, copy the one that works from B2,
then select the entire column and go to Edit|Paste Special and select Validation.
Click Ok...
Now the validation should be applied to the whole column.
Bookmarks