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.

Browse other questions tagged or ask your own question.