Thanks for the suggestion. Unfortunately, I can't use those. I have the VLOOPUP in column C because their values changes according to a previous step I have. If I use other types of form control, the user wouldn't be able to see which is "Perfect" and which is "No" or "Yes"

It's rather complex but I'll try to break it down.

The big picture is something like, there are 10 baskets. Depending on what kind of baskets the user wants, which he fills in the factors in different sheet, to generate the answer in column A. Based on column A, column C would give the "Perfect" value. Of course, the user could get other similar baskets, which "Yes" comes in at. Then there are baskets that don't fit at all, so "No". Column D would just have the baskets names. Eg. C1, Yes, D1, Basket Red; C2, No, D2, Basket Blue; C3, Yes, D3, Basket Orange. The values in column D don't change.

I have the option buttons in column B, next to the values (Yes, No, Perfect) so the user can pick whether they want the perfect basket or other similar ones.

That's not where it ends. In column E, I have a table that shows the details of the basket the user would select in column B (the option buttons). That's why I need option buttons, because the user must select only one item at a time.

What I want is to make the option buttons in columnn B unclickable/unable to select if the value in column C gives "No". Or something similar. Cause column E doesn't care for the value in column C, only what the user pick in column B. And I don't want the user to "Opps, I didn't know that baskets wasn't my type. I could select it so it's your fault!"

I'm not very familiar but I don't think the form controls works because the values in column C changes.