Please does anyone know if it is possible to prevent the contents of a cell being altered based on the value stored in that cell? To be more precise: If the cell value is "No Change" (which has been calulated by a formula) then the user should not be able to alter this. However if another cell in the same column has a different value then the user is allowed to alter it.
TIA
TIA