Hi Mike,

When applying Data Validation, select then entire range to have the
validation and then apply the validation as if only for the first cell of the
selection. Excel looks after applying correct formula to remaining cells in
the selection.

Select the range G1:G50 and then Data Validation - Custom.

Use the following formula for multiple strings to be excluded. (I have used
3 strings to exclude. Add as many as you like with comma between them
although there is an upper limit but not sure what that is.)

=AND(G1<"ULT",G1<"ABC",G1<"DEF")


--
Regards,

OssieMac