Data validation - allow a specific character OR range of numbers?

New Contributor

Hi, I'm trying to restrict values entered into a cell to "x", "/", or a whole number in the range of 5 to 29. I have worked out how to do it using a drop-down list, but I'd prefer to not have the drop-down lists. Is there a way to do this using a custom formula?

4 Replies


Let's say you want to apply this to H2:H50.

Select this range. H2 should be the active cell in the selection.

Use data validation of type Custom with formula


if you have Microsoft 365 or Office 2021, or


if you have an older version.



That'll do the job! It still allows the numbers from 1 through 4 to be input, but for my intents and purposes, it doesn't really matter. Thank you so much!
best response confirmed by mikeblogg (New Contributor)


Change the formula to




That's perfect! Thank you so much!