I have set up a sheet as a rota. It uses a few conditional formatting rules to highlight things that might need attention, like if a cell is empty and if a date is within the next 2 weeks.
However as people edit it, formatting rules seem to get messed up as they presumably copy-paste cells and this copies rules as well as contents, or copies the formatting on a cell to the new location.
Is there a way to prevent this, lock formatting rules or lock formatting entirely? It is a sheet with a fixed number of rows - one per week basically.