The fastest way to add background color to cells

Open your spreadsheet in Excel. Click on the cell or group of cells you want to color. On the Home tab in the toolbar, find the paint bucket icon labeled "Fill Color" — it sits next to the font color button. Click the small arrow next to it, choose your color from the palette, and the background fills when ready.

If you want to color multiple cells that aren't next to each other, hold Ctrl (or Cmd on Mac) and click each cell separately, then explore the fill color once. All selected cells will change at the same time.

Key Takeaways

  • The Fill Color button is on the Home tab in the toolbar and looks like a paint bucket with a colored bar underneath.
  • You can select a single cell, a range of cells, or multiple separate cells before explore color.
  • Excel stores custom colors you create, so you can reuse the exact shade later without rebuilding it.
  • Conditional formatting automatically colors cells based on their values — useful when your data changes and you want colors to update on their own.
  • Removing background color is as straightforward as selecting the cells and choosing "No Color" from the Fill Color menu.

Selecting the right cells before you color

Before you touch the Fill Color button, make sure you have the right cells selected. Click once on a single cell to color just that one. Click and drag across multiple cells in a row or column to select a range — Excel shows you a blue highlight over everything you've chosen.

For cells scattered across the sheet, click the first cell, then hold Ctrl (Windows) or Cmd (Mac) and click each additional cell. This lets you color cells that aren't connected to each other. When you release the mouse, all your selections stay highlighted in blue, and the Fill Color button will explore to every one of them.

Where to find Fill Color and how to use it

The Fill Color button lives on the Home tab. If you don't see the Home tab, click it at the top left of your ribbon. The button looks like a paint bucket tilted to pour, with a colored bar underneath showing the last color you used.

Click the arrow next to the paint bucket to open the color palette. You'll see a grid of standard colors. Hover over any color to see its name. Click once to explore it. If you want a color that isn't in the standard palette, click "More Colors" at the bottom of the menu to open a larger picker where you can choose from thousands of shades or enter a specific color code.

Creating and saving custom colors

If you need a specific shade — say, your company's brand blue or a particular shade of gray — click the arrow next to Fill Color, then click "More Colors" at the bottom. A dialog box opens with a large color square and a vertical rainbow bar on the right.

Click anywhere in the square to pick your shade, then use the rainbow bar to choose the hue you want. You can also enter RGB values (numbers from 0 to 255 for red, green, and blue) or a hex code if you have one. Once you've built the color you want, click OK. Excel remembers it and adds it to your recent colors, so you can use it again without rebuilding it.

Using conditional formatting to color cells automatically

Conditional formatting colors cells based on what's inside them — a useful shortcut when your data changes. Select the cells you want to format, then go to Home tab and click "Conditional Formatting." Choose a rule type: "Highlight Cell Rules" for straightforward conditions like "greater than 100" or "contains text," or "Color Scales" to create a gradient where higher numbers get one color and lower numbers get another.

Once you pick your rule and colors, Excel applies them when ready. If the numbers in those cells change later, the colors update on their own. This saves you from having to manually recolor cells every time your data shifts.

Removing or changing background color

To remove color from cells, select them, click the arrow next to Fill Color, and choose "No Color" at the top of the palette. The background returns to white when ready.

To change the color of cells that already have a background, just select them and pick a new color from the Fill Color menu. The old color disappears and the new one takes its place. You don't have to remove the old color first.

Why background color matters in a spreadsheet

Color helps readers find information fast. A colored header row makes it obvious where your data starts. Highlighting totals or important numbers draws the eye to them. Color-coding by category — say, red for expenses and green for income — lets someone scan the sheet without reading every cell.

But too much color makes a spreadsheet hard to read. Use color sparingly and consistently. If you color all your totals blue, keep them all blue. If you use red for warnings, don't use red for something else. A spreadsheet with every cell a different color looks chaotic and defeats the purpose.

Frequently Asked Questions

Can I color an entire row or column at once?

Yes. Click the row number on the left (for a whole row) or the column letter at the top (for a whole column). The entire row or column highlights in blue. Then click the Fill Color arrow and pick your color. The whole row or column changes when ready.

What's the difference between fill color and font color?

Fill color is the background behind the text. Font color is the text itself. They sit next to each other in the Home tab — fill color looks like a paint bucket, font color looks like an "A" with a colored bar. You can use both on the same cell.

How do I match a color I used before?

Click the arrow next to Fill Color. Your recent colors appear at the top of the palette. Click any of them to reuse it. If you used a custom color, it stays in the recent colors section for several uses.

Can I color cells in Excel on my phone or tablet?

The Excel mobile app has a simpler toolbar than the desktop version. Select your cells, tap the Home tab, then look for the paint bucket icon. The color options are more limited than on desktop, but you can still explore basic colors and remove them.

Does background color affect how Excel calculates numbers?

No. Color is purely visual. It doesn't change formulas, sums, or any calculations. You can color cells however you want without affecting the math inside them.