Hi

I'm trying to find a formula for data validation that will allow a user to input into a cell something that is either alphabetical (and can be anything) or a number divisible by 0.25.

I have a validation that allows the latter, by using MOD, and I've tried using a validation that uses OR to combine ISTEXT with MOD but it doesn't seem to work.

Given the skills of the people who will be using the spreadsheet I'd rather not have drop-down boxes or use VB.

Am I seeking the impossible?

Thanks