I am attempting to control the parameters of two cell inputs without writing a macro or putting in error handling code.
I have two contiguous cells where they start out with the condition "n/a" (i.e. C5 and D5). I am looking for a data validation "custom" formula for C5 that says, the input number must be a whole number from 1 to 10 but must also be lower then any number put in D5 which is populated after C5 (i.e. it still has "n/a" in Cell D5 until after C5 is chosen. D5 must be a number equal to or higher then C5 but less then 11 (i.e. 1-10 whole number) but may also be valid if it has "n/a" in the cell. Remember that both cells start out with "n/a" in them and will be reset to that so the validation must also be able to treat "n/a" without an error condition and I believe it automatically assigns a value of -0- to it.
Your help on this is much appreciated.