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

Get FREE Advanced Excel Exercises with Solutions!

In this article, we will learn to solve the unable to change font color in Excel issue. There are many times we need to change the font color in our Excel worksheet. But, sometimes, for various reasons, we can not change the font color in our Excel worksheet. Today, we will discuss the probable reasons that could arise and their solutions.


Unable to Change Font Color in Excel: 3 Solutions

To explain the solutions, we will use a dataset that contains information about the Department and the Age of some employees. Here, we will try to change the font color in the Age column.


1. Disable Hardware Graphics Acceleration to Change Font Color in Excel

Sometimes, we connect our device to an external monitor and work on our Excel sheet. In that case, we may not change the font color because of the hardware acceleration. So, if you face this problem because of hardware acceleration, you just need to disable it.

Let’s follow the steps below to learn the solution.

STEPS:

  • First of all, go to the File tab in the ribbon and select Options.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

  • Secondly, select Advanced and check the Disable hardware graphics acceleration box from the Display section.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

  • After that, select the cells where you want to change the font color.
  • Then, go to the Home tab and change the color from the Font section.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

  • Finally, you will be able to change the font color like the picture below.

Disable Hardware Graphics Acceleration to Change Font Color in Excel

Read More: How to Change Default Font in Existing Excel Workbook


2. Clear Conditional Formatting to Change Font Color

In the second solution, we will talk about conditional formatting. When conditional formatting is applied to certain cells, we can not change the font color. Here, we will use the same dataset. However, the cells in column D have conditional formatting.

Clear Conditional Formatting to Change Font Color

Now, select the cells of column D and try to change the font color like the picture below.

Clear Conditional Formatting to Change Font Color

However, it will not work on the selected cells because of conditional formatting.

Clear Conditional Formatting to Change Font Color

Let’s pay attention to the steps below to fix the problem.

STEPS:

  • In the first place, go to the Home tab and select Conditional Formatting. A drop-down menu will occur.

Clear Conditional Formatting to Change Font Color

  • Secondly, select Clear Rules and then, select Clear Rules from Entire Sheet.

Clear Conditional Formatting to Change Font Color

  • Finally, after clearing the rules, we will be able to change the font color like below.

Clear Conditional Formatting to Change Font Color

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


3. Unprotect Sheet in Excel to Change Font Color

There is another reason that can prevent us from changing the font color. And that is the protected sheet. When a sheet is protected, we can not change the font color. In this case, the options for changing the font color are disabled. We can see that in the below picture with the dataset.

Let’s observe the steps below to solve this issue.

STEPS:

  • In the beginning, go to the Review tab in the ribbon and select Unprotect Sheet. This will enable all options in the Home tab.

Unprotect Sheet in Excel to Change Font Color

  • In the second place, select the cells and try to change the font color from the Font section of the Home tab.

  • Finally, after unprotecting the sheet, you will be able to change colors very easily like below.

  • In conclusion, another thing should be added. If your sheet is protected with a password then, it will ask for the password while unprotecting the sheet.
  • So, in that case, you need to type the password in a message box like below.

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


Things to Remember

To apply any specific solution, you need to first look for the reason behind the problem. And then, apply the solution according to the problem. Otherwise, you need to apply all the solutions in your worksheet one by one.


Download Practice Book

Download the practice book here.


Conclusion

We have discussed 3 easy solutions to the Unable to Change Font Color in Excel issue. I hope these solutions will help you to fix your problem. Furthermore, you can also download the practice book to exercise. Last of all, if you have any queries or suggestions, feel free to ask in the comment section below.


Related Articles

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.

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