Thread: Data Validation Query
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Rhonda Anderson Rhonda Anderson is offline
external usenet poster
  
Posts: 2
Default Data Validation Query
"Bob Phillips" wrote in news:eiqbCrrxHHA.484
@TK2MSFTNGP06.phx.gbl:

Add DV with a type of Custom and a formula of

=IF(A1<"",myRange)

uncheck the Ignore Blank box.


Very helpful, thank you very much.

--
Rhonda Anderson
Cranebrook, NSW, Australia
Reply With QuoteReply With Quote