Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Change Background Color in Excel (6 Easy Methods)

It is of great help to change a cell background color or the whole worksheet’s background color at times. We can change a cell background color both statically and dynamically. This article will show you 6 quick ways to change background color in Excel.


Download Practice Workbook

You can download and practice from our workbook here.


6 Simple Methods to Change Background Color in Excel

Go through the following easy methods to enhance your knowledge about changing the background color in Excel.

1. Change Cell Background with Fill Color

You can change a cell’s background color using the Fill Color option. Follow the steps below to do so. 👇

Steps:

  • First, select the cell in which you want to change the background color. Then, go to the Home tab >>click on the Fill Color icon >> Choose the color you want from the dropdown list.

Use the Fill Color Icon to Change Background Color in Excel

  • Apart from the first step, you can follow this step flow too. Select the cell >> go to the Home tab >> Choose the Font Settings icon from the Font group.

Use the Font Settings Icon to Change Background Color in Excel

  • The Format Cells window will appear. Go to the Fill tab. Subsequently, choose the color that you want as the background from the color palette. Click on the OK button. In addition to this, If you want more colors or customized colors, click on the More Colors… button.

Choose More Colors

  • Subsequently, the Colors window will appear. Choose the standard or Custom color from here and click on the OK button.

  • Apart from the first 4 steps, you can follow another way. In this regard, right-click on your desired cell. Choose Format Cells… from the context menu. Subsequently, follow steps 2 and 3 stated here.

Use the Format Cells Option to Change Background Color in Excel

Thus, you can change any cell’s background following this method. Here is a quick look at our result worksheet. 👇

Changed Background Using Fill Color

Read More: How to Modify Theme Color, Font, & Effects & Create Custom Excel Theme


2. 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.

Go to Format Cells for Fill Effect or Pattern

  • At this time, the Format Cells window will appear. Go to the Fill tab. 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.

Choose the Pattern Color & Style

  • After doing these, you will see a sample preview in the Sample box. Subsequently, click on the OK button.

View the Sample Preview of the Chosen Pattern

  • Now, for the fill effect background, choose the Fill Effects… option from the Fill tab.

Apply Fill Effect to Change Background Color in Excel

  • At this time, the Fill Effects window will appear. Choose the Two colors option from the Colors list. Subsequently, choose your shading style from the Shading styles options, and afterward, choose a variant from the Variants samples. Consequently, click on the OK button.

Choose the Fill Effect

Thus, You can change a cell’s background with a fill effect or pattern easily using this trick. Here is a quick look at our result worksheet. 👇

Changed Background Using Fill Effect & Pattern in Excel

Read More: How to Apply Parallax Theme in Excel (With Easy Steps)


3. Use Conditional Formatting

Besides, you can change a cell’s background using conditional formatting. Follow the steps below to accomplish this. 👇

Steps:

  • At first, select the cells where you want your conditional formatting applied. Subsequently, go to the Home tab >> Conditional Formatting >> New Rule…

Use Conditional Formatting to Change Background Color in Excel

  • At this time, the New Formatting Rule window will open. Choose the rule type Use a formula to determine which cells to format from the listed rules. At the rule description text box, write the formula: =B4=“light green color”. This formula means the condition will be applied to the cells where the light green color is written. Click on the Format button.

Choose the Condition for Formatting

  • The Format Cells window will appear afterward. Choose the color from here. Click on the OK button. Moreover, you can also follow steps 2,3,4, and 5 from method 2 to apply the fill effect or pattern format.

Choose the Format for the Formatting

  • After setting the format, you can see the preview in the Preview box. Click on the OK button.

Watch the SAmple Preview of the Conditional Formatting

Thus, you can change the background color of specific cells using conditional formatting. Here is a quick view of our result worksheet. 👇

Changed Background Color in Excel with Conditional Formatting

Read More: How to Create an Excel Theme (Step by Step Guide)


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: 

  • Click on the shaded right-angle triangle at the intersection of row and column headings. This will select all the cells of the sheet.

Select all the Cells

  • Now, go to the Home tab >> click on the Fill Color icon >> select the color you want for the background.

Choose Background Color

Thus, you can change the whole worksheet’s background color in this way which looks like this. 👇

Changed Background of the Whole Worksheet in Excel

Read More: How to Apply a Theme to a Workbook in Excel (2 Suitable Ways)


5. Utilize the Find Tool

You can also change the background color of a cell using the Find tool. Follow the steps below to accomplish this. 👇

Steps:

  • At first, select the cells where you want your background changed to specific conditions. Go to the Home tab >> go to the Editing group >> click on Find & Select tool >> click on the Find… option from the dropdown list.

Access the Find tool to Change Background Color 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 button.

Use Find All Button to Find the Specific Cells

  • 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.

Select All the Required Cells

  • Consequently, go to the Home tab >> click on the Fill Color icon >> select the color you want.

Choose the Background Color

Thus, you will successfully find and change the desired cell’s background color in Excel. The result of the worksheet will look like this. 👇

Changed Background Color Using the Find tool in Excel

Read More: How to Change Theme Font in Excel (2 Easy Ways)


6. Change Background Color Using VBA

Moreover, you can change a cell’s background color using VBA code. Follow the steps below to do so. 👇

Steps:

  • At first, go to the Developer tab >> click on the Visual Basic tool.

Go to the Visual Basic Tool

  • At this time, the Microsoft Visual Basic for Applications window will appear. Now, select Sheet 4 and write the following code in the code window.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim XRange As Range
Set XRange = Range("B4:D8")
If Not Intersect(Target, XRange) Is Nothing Then
Target.Interior.Color = rgbLightGreen
Else
End If
End Sub
  • Now, exit the Microsoft Visual Basic for Applications window and go to the File tab.

  • Choose the Save As option from the expanded File tab.

  • Subsequently, choose the Save as type as .xlsm file to enable the macro. Click on the Save button.

Save the Excel as .xlsm File to Enable Macro

  • Now, whenever you click on a cell between the declared range, the cell background will turn into light green color.

Thus, our result worksheet will look like this if we click on the C5 and C8 cell.

Double-Click & Change the Background Color Using VBA in Excel

Read More: How to Change Background Color to Grey in Excel (Step by Step)


Things to Remember

  • For removing a fill color, you can go to the Home tab >> click on the Fill Color icon >> click on the No Fill option from the dropdown list.

Remove any Background Color

  • When using conditional formatting to a range of data, don’t use absolute reference, rather, use relative reference for checking the condition dynamically.

Conclusion

So, in this article, I have shown you the 7 easiest tricks to change background color in Excel. Use any of these ways in this regard according to your preference and desired result. I hope you find this article helpful and informative. If you have any further queries or recommendations, please feel free to contact me. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Tags:

Tanjim Reza

Tanjim Reza

Hello! I am Md. Tanjim Reza Tanim. I have just completed my B.Sc from Naval Architecture & Marine Engineering Department, BUET. Currently, I am working as an Excel & VBA content developer. I always had a great fascination with Microsoft Excel and its cool functions and formulas. Here, I am learning every day about new functions and formulas and working on applying MS Excel to the analysis of our real-life problems. I have great enthusiasm for learning any kind of new things, writing articles, and solving real-life problems.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo