Lock range based on cell value

[thegreencar]

Hi,
I am trying to come up with process for an online Excel sheet which will lock access to a range if a cell is set to "Yes"

Please see below link.
https://mcafee-my.sharepoint.com/:x...aa7ccd270d46a1b81526e233bea883&csf=1&e=xG0xY6

I will be sharing this file so need the locking of the cells to happen automatically.
The conditional cells in column D, Yes/No are already on restricted access to prevent users from selecting.

Really stuck on this so would really appreciate any help here.

Thanks,

 

[Chrisdontm]

The only way I think you could do that is with an IF statement in a macro...