hi all
can anyone help please
on a excel sheet i need h1 to only allow certain numbers to be entered, if any other numbers are entered then an error message to show
i.e only the numbers 2, 4, 5, 8, 9, 10, 12, 14, 17, and 22 need to be entered in cell h1 for other calculations to be carried out. any other number can be entered but on doing so i would like a error message to show
many thanks
can anyone help please
on a excel sheet i need h1 to only allow certain numbers to be entered, if any other numbers are entered then an error message to show
i.e only the numbers 2, 4, 5, 8, 9, 10, 12, 14, 17, and 22 need to be entered in cell h1 for other calculations to be carried out. any other number can be entered but on doing so i would like a error message to show
many thanks