[Fixed!] Background Color Not Changing in Excel (6 Solutions)

While changing the background color of cells in Microsoft Excel, sometimes we notice that we are not able to change the background color. This happens due to several reasons. Locking the worksheet is one of them. We can easily fix the error. This is a time-saving task also. Today, in this article, we’ll learn six quick and suitable ways to solve the error named background color not changing in Excel effectively with appropriate illustrations.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


Reason Behind Background Color Not Changing in Excel

The worksheet’s default fill color cannot be changed in Excel. Every cell in a worksheet has no fill by default. However, you may construct an Excel template if you routinely generate workbooks that have worksheets with cells that all have a particular fill color. If the cell is locked, you can not change the background color of those cells.

background color not changing in excel


6 Easy Ways to Fix the Background Color Not Changing in Excel

Go through the following easy methods to fix the problem and enhance your knowledge about changing the background color in Excel. Here’s an overview of the dataset for our today’s task.

background color not changing in excel


1. Use Fill Color Command to Change Cell Background Color

Using the Fill color option, you can change the background color. From our dataset, we will change the background color of the highest marks. Let’s follow the instructions below to learn!

Steps:

  • First of all, select a cell for the convenience of our work. Let’s say, we will select cell D13. After that, from your Home ribbon, go to,

Home → Font → Fill Color

Use Fill Color Command to Change Cell Background Color

  • As a result, you will be able to change the background color from No Fill color to Green which has been given in the below screenshot.

Read More: How Do I Change the Default Background Color in Excel


2. Apply Conditional Formatting

Now, we will apply conditional formatting to change the background color of several cells. From our dataset, we will change the background color of those cells whose value is less than 45. This is an easy and time-saving task also. Let’s follow the instructions below to learn!

Step 1:

 

 

  • First of all, select a cell range for the convenience of our work. Let’s say, we will select cells B4 to F14.

background color not changing in excel

  • After that, from your Home ribbon, go to,

Home → Styles → Conditional Formatting → Highlight Cells Rules → Less Than

Step 2:

  • As a result, a Less Than dialog box will appear in front of you.
  • From the Less Than dialog box, firstly, type 45 under the Format cells that are LESS THAN typing box.
  • Secondly, select a color from the drop-down box named with. We select Light Red Fill with Dark Red Text.
  • At last, press the OK option.

background color not changing in excel

  • After completing the above process, you will be able to change the background color.

Change Cell Background with Patterns or Fill Effects


3. Change Cell Background with Patterns or Fill Effects

You can change a cell’s background as some pattern or effect too. Follow the steps below to accomplish this.

Steps:

  • At first, choose the cell in which you want to change the background. Subsequently, right-click in the cell and choose the Format Cells… option from the context menu.

  • At this time, the Format Cells window will appear. Go to the Fill Now, for the pattern background, choose your desired pattern color from the Pattern Color dropdown list.
  • Subsequently, choose the pattern style from the Pattern Style dropdown list.
  • Hence, select the Fill Effects option.

Change Cell Background with Patterns or Fill Effects

  • After that, a Fill Effects dialog box pops up. From the Fill Effects dialog box, Choose the Two colors option from the Colors list.
  • Subsequently, choose your shading style from the Shading styles options.
  • Afterward, choose a variant from the Variants samples.
  • Consequently, click on the OK button.

  • Again, click on the OK option.

Change Cell Background with Patterns or Fill Effects

  • Further, you will be able to change the background color using the Fill effects option.

Use Excel Paint Bucket to Color the Background of a Worksheet

Read More: How to Make Picture Background Transparent in Excel (2 Methods)


4. Use Excel Paint Bucket to Color the Background of a Worksheet

You can change the whole worksheet background color by using the Paint Bucket tool. Follow the steps below to do so.

Steps:

  • To change the whole worksheet background color by using the Paint Bucket tool, firstly, select the entire worksheet. To do that, press Ctrl + A on your keyboard simultaneously.

  • After that, from your Home ribbon, go to,

Home → Font → Fill Color

Use Excel Paint Bucket to Color the Background of a Worksheet

  • As a result, you will be able to change the background color from No Fill color to Dark Blue which has been given in the below screenshot.

Read More: How to Make Excel Spreadsheet Colorful (6 Simple Tricks)


5. Utilize the Find Tool

In this method, we will apply the Find tool to change the background color. Let’s follow the instructions below to change the background color!

Steps:

  • First of all, select the cells where you want your background changed to specific conditions. Hence, press Ctrl + F on your keyboard simultaneously.

background color not changing in excel

  • At this time, the Find and Replace window will appear. On the Find tab, write what you want to find in the Find what text box. Suppose, we want to find the blank cells. So, we leave the text box empty. Subsequently, click on the Find All option.

  • Subsequently, the blank cell references will be shown in an added portion of the Find and Replace window. Now, drag and select all the cell references.

background color not changing in excel

  • After that, from your Home ribbon, go to,

Home → Font → Fill Color

  • As a result, you will be able to change the background color of the blank cells from No Fill color to Red which has been given in the below screenshot.

Run a VBA Code to Change Background Color in Excel


6. Run a VBA Code to Change Background Color in Excel

Last but not the least, I’ll show how to change the background color using a simple VBA code. It’s very helpful for some particular moments. From our dataset, we will change the background color using a simple VBA code. Let’s follow the instructions below to change the background color using a simple VBA code!

Step 1:

  • First of all, open a Module, to do that, firstly, from your Developer tab, go to,

Developer → Visual Basic

  • After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Background Color Not Changing will instantly appear in front of you.
  • From that window, we will insert a module for applying our VBA code. To do that, go to,

Insert → Module

Run a VBA Code to Change Background Color in Excel

Step 2:

  • Hence, the Background Color Not Changing module pops up. In the Background Color Not Changing module, write down the below VBA code.
Private Sub Background_Color_Change(ByVal Target As Range)
Dim X As Range
Set X = Range("B6:F14")
If Not Intersect(Target, X) Is Nothing Then
Target.Interior.Color = rgbRed
Else
End If
End Sub

  • Hence, run the VBA To do that, go to,

Run → Run Sub/UserForm

Run a VBA Code to Change Background Color in Excel

Step 3:

  • After running the VBA code, go back to your Excel worksheet, and select any cell. As a result, you will be able to change the background color of the cells from No Fill color to Red which has been given in the below screenshot.

Read More: Excel VBA to Open Workbook in Background (2 Useful Examples)


Things to Remember

👉 The other way is to unprotect a worksheet to change the background color. Hence, you will use the Fill color option to change the background color.

👉 #N/A! error arises when the formula or a function in the formula fails to find the referenced data.

👉 #DIV/0! error happens when a value is divided by zero(0) or the cell reference is blank.


Conclusion

I hope all of the suitable methods mentioned above to fix the background color do not change errors and will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.


Related Articles

Md. Abdur Rahim Rasel

Md. Abdur Rahim Rasel

Hi! I'm Md. Abdur Rahim Rasel. Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. I have completed my graduation in Naval Architecture and Marine Engineering(NAME) from Bangladesh University of Engineering and Technology(BUET). I have a passion for learning new things with my knowledge through perseverance and hard work.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo