ExcelBanter - datavalidation conditional list

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - datavalidation conditional list (https://www.excelbanter.com/excel-discussion-misc-queries/136659-datavalidation-conditional-list.html)

TUNGANA KURMA RAJU

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.

All times are GMT +1. The time now is 10:03 PM.