I am trying to lock cells (which has values from a drop down list) depending on value from another cell.
Column A has drop down list with 2 values (On/Off)
Column B has drop down list of XXX values
Column C is free text field
if Cell A2 is On, user can only edit C2 and B2 is locked (no option to view the drop down as well)
if Cell A2 is Off, user can only enter value in B2 and C2 is locked.
Can you please help on how I can proceed?