Is there a way to protect only some cells from re-formatting?
Assuming you mean you want to allow them to enter data into the protected cells but do not want them to format the protected cells, do the following (these instructions are for Excel 2019 and the method may be slightly different for earlier versions):
- Select all required protected cells
- Go to 'Format > Format Cells'
- Click on the 'Protection' tab
- Untick 'locked'
- Click on 'OK' to exit the dialog box
- Now go to 'Format > Protect Sheet'
- Scroll down the list and tick 'Edit objects'
- Make sure the 'Format cells' option is unticked if it isn't already
- Optionally browse the list and tick or untick anything else you're interested in
- Click 'OK' to exit.
That should do it.