[Fixed!] Unable to Change Font Color in Excel (3 Solutions)

To explain our solutions we will use the dataset below, and try to change the font color in the Age column.


Solution 1 – Disable Hardware Graphics Acceleration

If we connect our device to an external monitor, we may not be able to change the font color due to hardware acceleration. If this is the cause of the issue, we just need to disable it.

Steps:

  • Go to the File tab in the ribbon and select Options.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

  • Select Advanced and check the Disable hardware graphics acceleration box from the Display section.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

  • Select the cells where you want to change the font color.
  • Go to the Home tab and change the color from the Font section.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

You will now be able to change the font color.

Disable Hardware Graphics Acceleration to Change Font Color in Excel


Solution 2 – Clear Conditional Formatting

When conditional formatting is applied to certain cells, we cannot change the font color. Here, we use the same dataset, however the cells in column D have conditional formatting.

Clear Conditional Formatting to Change Font Color

  • Select the cells of column D and try to change the font color like in the picture below.

Clear Conditional Formatting to Change Font Color

It will not work on the selected cells because of their conditional formatting.

Clear Conditional Formatting to Change Font Color

Removing the conditional formatting will fix the problem.

Steps:

  • Go to the Home tab and select Conditional Formatting.

Clear Conditional Formatting to Change Font Color

  • Select Clear Rules from the drop-down list that appears, then Clear Rules from Entire Sheet.

Clear Conditional Formatting to Change Font Color

After clearing the rules we will be able to change the font color.

Clear Conditional Formatting to Change Font Color

Read More: How to Change Font in Excel to All Caps


Solution 3 – Unprotect Sheet

When a sheet is protected we cannot change the font color, because the options for changing the font color are disabled.

Unprotecting the sheet will solve this issue.

Steps:

  • Go to the Review tab on the ribbon and select Unprotect Sheet.

This will enable all options in the Home tab.

Unprotect Sheet in Excel to Change Font Color

  • Select the cells, and try to change the font color from the Font section of the Home tab.

Font colors can be changed as normal again.

If your sheet is protected with a password, you will need to enter the password to unprotect the sheet.

Read More: How to Change Font in Excel for All Sheets


Download Practice Book


Related Articles

<< Go Back to Excel Fonts | Excel Cell Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

Tags:

Mursalin Ibne Salehin
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo