Thread: datavalidation conditional list
View Single Post
  #1   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
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