Thread: datavalidation conditional list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
  
Posts: 171
Default datavalidation conditional list
Thank you ,Toppers

"Toppers" wrote:

See:

http://www.contextures.com/xlDataVal02.html

"TUNGANA KURMA RAJU" wrote:

I have datavalidation in cell a2 with a list of two data values
"Yes","No".In cell b2 I am trying to insert a datavalidation list of 5
datavalues("CentralGovt","PublicSector","StateGovt ","ArmedForces","ParaMilitary")
,if cell a2="Yes". Otherwise cell b2 should be blank.I can't figure it
through custom method.
Reply With QuoteReply With Quote