We love to modify everything for the betterment. Even in the case of using Excel, we try to change the default background color of the Worksheet to modify its appearance. In this article, we are going to learn how do I change the default background color in Excel. Show
Download Practice WorkbookDownload this practice workbook to exercise while you are reading this article. 7 Easy Ways to Change the Default Background Color in ExcelGo through the following easy methods to enhance your knowledge about changing the default background color in Excel. Here’s an overview of the dataset for our today’s task. 1. Use Fill Color Command to Change Default Background ColorUsing 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:
Home → Font → Fill Color
Read More: [Fixed!] Background Color Not Changing in Excel (6 Solutions) 2. Apply Conditional Formatting to Change Default Background ColorNow, 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:
Home → Styles → Conditional Formatting → Highlight Cells Rules → Less Than Step 2:
Read More: How to Change Background Color Based on Value in Excel 3. Change Default Background with Patterns or Fill EffectsYou can change a cell’s background as some pattern or effect too. Follow the steps below to accomplish this. Steps:
Read More: How to Make Picture Background Transparent in Excel (2 Methods) 4. Use Excel Paint Bucket to Color the Default Background of a WorksheetYou can change the whole worksheet background color by using the Paint Bucket tool. Follow the steps below to do so. Steps:
Home → Font → Fill Color
Read More: How to Remove Background in Excel (2 Practical Cases) 5. Utilize Find Tool to Change Default Background ColorIn 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:
Home → Font → Fill Color
Read More: How to Remove Background Color in Excel (5 Ways) 6. Unprotect Worksheet to Alternate the Default Background ColorIf your Excel worksheet is protected, first you should unprotect it to change the default background color. Let’s follow the instructions below to learn! Steps:
Home → Cells → Format → Unprotect Sheet
Read More: How to Change Worksheet Tab Color in Excel (5 Handy Methods) 7. Run Excel VBA Code to Change the Default Background ColorLast 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:
Developer → Visual Basic
Step 2:
Run → Run Sub/UserForm Step 3:
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. ConclusionI hope all of the suitable methods mentioned above to change the default background color 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
Which command allows you to color the background of the cell?Select the cell or range of cells you want to format. Click Home > Format Cells dialog launcher, or press Ctrl+Shift+F. On the Fill tab, under Background Color, pick the color you want.
Which tab is used to apply background color?The Background tab in the Style Editor allows you to modify the background color and image of the entire package, individual pages, columns on a page, or individual blocks.
How to change cell background color in Excel using if statement?Changing the background color of Excel cells using the “If – function”. Prepare a list. As a starting point, prepare a list of all your accounting transactions. ... . Choose “Conditional formatting” ... . Select your formatting features. ... . Enter formatting conditions. ... . Confirm your selection. ... . Check the result.. |