[Fixed!] Unable to Change Font Color in Excel (3 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.


Download Practice Book

Download the practice book here.


3 Solutions to the Excel Problem: Unable to Change Font Color

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: Excel VBA: Change Font Color for Part of Text (3 Methods)


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. But, 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

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 Use VBA Code to Change Font Color in Excel (3 Methods)


Similar Readings


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 Size of the Whole Sheet with Excel VBA


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.


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

Mursalin

Mursalin

Hi there! This is Mursalin. I am an Excel and VBA content developer as well as an electrical and electronics engineer. I am always motivated to gather knowledge from different sources and find solutions to problems in easier ways. I am currently working and doing research on Microsoft Excel. Here I will be posting articles related to Microsoft Excel.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo