No Data validation selection based on cell value

[harinsh]

Hi Team,

Hope can anyone help on the below request.

I have two data validation columns and I would to get the second validation based on first selection. Expecially if I select "No" in first column (A2) then in B2 data validation should not require to appear the drop down. It should block the validation.

Can anyone help on this request.

Thanks,

 

[VoG]

Maybe ths will help http://www.contextures.com/xlDataVal02.html

 

[harinsh]

Thanks for your link, but I have one question here, I should not get the drop down list if cell contains specific text. How can I do this? Thanks