In this article, you will learn how to change the background color of a cell in Excel and Google Sheets.
Change the Background Color
To change a cell’s background color, click on the cell (B2, in this example).
Then in the Ribbon, go to Home > Fill Color and choose a color (e.g., Blue, Accent 1, shown below).
The background of cell B2 is now filled with the color Blue, Accent 1. As you move the cursor over colors, the cell color will change, but you have to click on the color to confirm the change.
To clear the color of the cell, click again on cell B2 and in the Ribbon, go to Home > Fill Color > No Fill.
Now the background color of B2 is removed.
Apart from the standard colors offered in the Fill Color menu, there are more colors from the palette to choose from.
1. Select the cell and in the Ribbon, go to Home > Fill Color > More Colors.
2. In the pop-up screen, choose a color and click OK.
There’s also the option to use the RGB color code or Hexadecimal to fill the cell background.
In the Colors window, (1) go to the Custom tab, (2) enter the RBG or Hex code, and (3) click OK.
You can also click on any color, and the RBG and Hex codes will be populated based on the chosen color.
All colors added through the More Colors option will be added as Recent Colors in the Fill Color menu and can easily be used again.
Change the Cell Background Color in Google Sheets
To change the cell background color in Google Sheets, (1) select the cell and in the Toolbar, (2) go to Fill Color and (3) choose the color (e.g., orange, shown below).
As a result, the cell B2 background is now filled with orange.
To clear the cell background, (1) select the cell again, and in the Toolbar, (2) go to Fill Color and (3) click Reset.
After this, cell B2 has no background color.
As in Excel, you can use the Hex code to select an additional color.
1. Select the cell and in the Toolbar, go to Fill Color. Then click the plus sign under Custom.
2. In the pop-up window, enter the Hex color code and click OK.
If you don’t know the hex code, you can choose a color on the palette, and the hex code will be populated automatically.
As a result, the cell B2 background is filled with the custom color. If you go back to the Fill Color menu, this new color is added under Custom colors and can be reused anytime.