I've seen lots of posts about how to disable a cell based on the content of another cell, however I want to disable/re-enable cells based on the user clicking/selecting another cell. The range of affected cells are in this case, C12:C15 (these are the cells the user can select) and C18:C27 (these are the cells to be disabled/re-enabled).

For example, if the user clicks

Cell C12 it should disable Cells C19:C27
Cell C13 it should disable Cells C18 and C22:C27 and re-enable C19:C21
Cell C14 it should disable Cells C18:C21 and C25:C27 and re-enable C22:C24
Cell C15 it should disable Cells C18:C24 and re-enable C25:C27

Is this possible to do?

Ideally, I would like the disabled cells to be 'greyed out' as well, would this have to be done using 'conditional formatting' or could it be achieved as part of any code?

Many thanks