What about this?



All the cells that need to be edited are highlighted in Green. 
Every other format is directly computed from those green cells cells.
Settling a unique format for the cells to be edited can be a nice idea, even more if this is coherent across the various spreadsheets.