If cell = "yes" allow text entry into a group of cells

[rguliuzza]

Dear Excel Gurus,

I am in a dilemma and can use some assistance.

I have a drop down "Yes/No" box in Cell D33.

If someone chooses "Yes" then I want to allow them to enter information in cell block B35 - B45, otherwise they will get an error if they try to enter information into those cells.

Is there a quick way to resolve this?

I appreciate your assistance.

With best regards,
Rick

 

[bbott]

You can do this through Data Validation on the Data tab.

Select 'Custom' and enter this as the formula:

=D33="Yes"

Make sure to uncheck the 'Ignore Blank' box so that the user must select from the drop down.

 

[rguliuzza]

Dear bbott,

That is great and easy! I appreciate it!

With best regards,
Rick

 

[bbott]

Dear bbott,

That is great and easy! I appreciate it!

With best regards,
Rick

You're welcome!