Allow cells to be conditionally formatted to be locked
I would like to be able to put conditional formatting on cells that allows them to be locked in certain cases, and leave them unlocked in other cases. For example, if someone selects "Yes" for an answer, leave cell B1 unlocked so they can fill it out. If they answer "No", no further info is needed so lock cell B1 (which will allow them to tab directly to the next unprotected cell in a protected worksheet). This would help eliminate confusion on what needs to be filled out and also help speed up the process of filling it out.