Forum Discussion
Protected sheet allows cell formatting but not font colour change
I have an Excel spreadsheet that users access and edit online. The sheet is protected and users can select unlocked cells and format cells. Until recently, users could change the font colour but th...
It is possible that the protection settings for the sheet have been changed. When you protect a sheet in Excel, you can specify which actions are allowed for users. If the Format cells option is checked, users will be able to format cells, including changing the fill color.
However, if the Format cells option is not checked, users will not be able to change the font color.
Here are the steps you can take to set the protection settings for a sheet in Excel for the web:
- Open the Excel spreadsheet in Excel for the web and select the cells that you want to lock or unlock.
- On the Home tab, click on the Format button and then click on Format Cells.
- In the Format Cells dialog box, go to the Protection tab and check or uncheck the Locked option as needed.
- Click on OK to apply the changes.
- On the Review tab, click on Protect Sheet.
- In the Protect Sheet dialog box, check or uncheck the options as needed to allow or disallow specific actions by users.
After following these steps, users should be able to format cells on the protected sheet, including changing the fill color and font color.