Hi,
For eg, if i want to ,say a1 to d11 to contain specific numbers , then these cells should allow. Otherwise, it shows validation error messages.
Say, the numbers, that it should accept are 0,2,4,5,Na. Otherwise it should give the error message.I tried the custom format, but how could i make excel to accept specific numbers in so that it accept only the above mentioned numbers