Select as many cells in column H as you need, say from H1 to H10, and apply
this custom validation formula:
=AND($J$10<"",H1=0.01,H1<=40000)
Uncheck Negligate blank cells (if I re-translate it well, it's the checkbox
on the right side)

Regards,
Stefi

€žSean€� ezt Ã*rta:

I have the following Data Validation within the Custom criteria under
formula. It disallows input in cell H if J10 is blank.

=J10<""

How could I also include a criteria that will only accept decimal
inputs between 0.01 and 40000?