I've created a Google Sheets document intended for daily use by more than a dozen people. Text inputted in two of the columns is set up, via conditional formatting, to change colour based on the name entered (Smith = Red, Baker = Blue, Williams = Green and so on). I'm also running a script that forces all entries in these columns to be capitalised.
The issue I have is that all users need to be able to move the column entries up and down as and when required. For example, a job may be scheduled at 6am, then need to be moved down to an 8am slot.
When that happens, the formatting breaks and has to be replaced.
I understand there may be a way to lock or force the formatting using a control column/row and a script, but nothing I've tried seems to work. Any help or pointers would be much appreciated!