If cell dropdown equals no, then make a range of cells uneditable?

Hi guys,

Title basically states my issue. Right now I have a drop down with either Yes/No or A/B/C options with the data validation function. What I'm trying to get is if say A1 = Yes then nothing happens but if A1 = No then A2 & A3 is greyed out or uneditable/protected or at the very least it populates with a centered "N/A". A combination of all 3 would be perfect I can get away with less if it's going to get too messy.

I've taken a look in conditional formatting and while I can get A2 & A3 to grey out it doesn't do anything to prevent users from entering data.

Anyone have any thoughts?

Hi and welcome to the forum

CF is purely cosmetic, it just changes the appearance of a cell or range of cells, not what is inthem or what can/cannot be dont with them

What you might want to look into doing is using Data Validation for the cell you dont want "available?

If you upload a sample workbook, I can take a look and see if this might be an option for you?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

In the file you uploaded, try this.

Highlight B2:C2
under Data, select Data Validation
in the drop-down under "allow", select "custom"
enter =$A2<>"NO"
select OK

Now, put a NO on A2, and then try and type anything in B2:C2
change the NO to YES and you can enter stuff again
You can still apply CF to change colors etc, if you want

Is that something you can work with?

Thanks humding, I was afk for a while