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/136393-re-datavalidation-conditional-list.html)

Toppers

datavalidation conditional list

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.

TUNGANA KURMA RAJU

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.

All times are GMT +1. The time now is 01:59 AM.