Forum Discussion
Protected sheet allows cell formatting but not font colour change
It is possible that this is a programming issue with Excel online, as you mentioned.
One thing you can try is to check if there are any specific font colors that are allowed for the protected cells. In Excel, you can set up specific allowed values for certain cells or ranges of cells.
If the font color you are trying to use is not one of the allowed values, it will not be available to use.
To check if there are any allowed values for font color, select the protected cells and go to the Data Validation option in the Data tab of the ribbon.
In the Data Validation dialog box, select the Settings tab and look for any restrictions on the font color.
If there are restrictions, you can remove them or modify them as needed.
If there are no restrictions on font color, it may be worth checking if there are any add-ins or other customizations that are interfering with the font color option. You can try disabling any add-ins or customizations and see if that resolves the issue.
May be you can try to solve this with VBA.
However, please note that the level of protection may vary depending on the type of account you are using (e.g. personal, business, or educational) and the settings configured by your organization's administrator. If you are still experiencing issues with formatting cells after following these steps, you may need to check your organization's policies or contact your administrator for further assistance.
I hope this helps!
SeanOCDJ Hello! Did you manage to find any solution? We have this problem since april and I'm really looking forward to a solution but unfortunatelly I found nothing.
Thank you!
