How to Add a Background Color to a Cell in Google Sheets

A massive spreadsheet filled with endless rows of black text on a white background is incredibly difficult to read. Adding a background color (often called “Fill Color”) to specific cells is the easiest way to organize your data visually. You can use colors to differentiate the header row from the data rows, highlight specific columns, or draw attention to critical warning metrics.

How to Add a Solid Background Color

Applying a background color takes just two clicks using the toolbar menu.

1. Open your Google Sheets document.
2. Click on the specific cell you want to color. (You can also click and drag your mouse to highlight a massive block of cells, an entire row, or an entire column).
3. Look at the toolbar at the top of the screen. Locate the icon that looks like a tipping paint bucket with a drop of paint falling out. This is the “Fill color” tool.
4. Click the paint bucket icon. A large color palette will drop down.
5. Click on any color in the palette.
6. The highlighted cells will instantly change to the selected background color.

How to Create a Custom Color

If the default palette doesn’t match your company logo or branding requirements, you can input exact, custom hex codes.

1. Highlight your cells and click the paint bucket icon.
2. Look at the bottom of the color menu for the section labeled “Custom.”
3. Click the small Plus (+) button underneath “Custom.”
4. A new menu will appear. You can click and drag the cursor around the color spectrum to visually create a new color, or you can type an exact 6-character “Hex” code (e.g., #FF5733) into the box at the top.
5. Click OK to apply the custom color to your cells.

How to Remove a Background Color

If you made a mistake or want to redesign your spreadsheet, you can easily strip the color away.

1. Highlight the colored cells you want to fix.
2. Click the paint bucket icon in the toolbar.
3. At the very top of the drop-down menu, click the circular button labeled Reset (it has a red diagonal line through it).
4. This removes all formatting and returns the cell background to its default transparent/white state.

A Note on Text Contrast

When you apply a very dark background color (like dark blue or black), the default black text inside the cell will become invisible. You will need to change the text color to white to make it readable. You can do this by highlighting the cell, clicking the Text color icon (the letter ‘A’ with a thick line underneath it) in the toolbar, and selecting white.