Lock formula but allow colouring of the cell?

Question

Can anyone tell me how to lock a formula in a cell but allow the users to format the colour of the cell?

Solution

Yes, you must protect the sheet, but allow formatting.

Go to the review tab, changes group and select protect sheet.

The third box down in the new window is format cells, so place a check mark in this box to allow users to format the cells.