Diabling the next columns in excel 2010 when a condition is selected for the prior column.

[nave1984]

Hi,
I am building a tracking sheet . I want help for the below
Can someone help me in building something like - IF I select Yes from a drop down than the next 2 columns are disabled and If I select No from the drop down The next two columns are enabled.
Please see attached file for reference.

Thanks
Nave

[Ace_XL]

Try Data validation..

Allow Text length--> between --> minumum--> 0---> maximum-->=IF(A2="Yes",0,999999)

[Ace_XL]

Nave1984,

Welcome to the forum and thanks for the rep!

If you are happy with the solution provided, please mark the thread solved.
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

[nave1984]

Thanks for the help have marked it solved
Thanks again