View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default 2 Data Validations Q

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?