The fastest way to color a cell in Excel

To change a cell's background color in Excel, select the cell or cells you want to color, then click the paint bucket icon (called Fill Color) in the toolbar and pick your color. The paint bucket sits in the Home tab on the ribbon, usually near the font color button. One click applies the color when ready.

If you don't see the paint bucket icon, your ribbon may be collapsed. Click the Home tab at the top of the screen to expand it. The icon looks like a small bucket tipping paint and usually has a colored bar underneath showing the last color you used.

You can color a single cell, a row, a column, or any group of cells at once. Just select them all before you click the paint bucket. To select multiple cells that aren't next to each other, hold Ctrl (or Cmd on a Mac) and click each one.

Key Takeaways

  • The Fill Color button (paint bucket icon) in the Home tab is the quickest way to add background color to any cell or group of cells.
  • You can select one cell, multiple cells in a row, an entire column, or scattered cells before explore color.
  • Clicking the small arrow next to the paint bucket opens a color palette with standard colors, custom colors, and theme colors.
  • To remove a color you've already applied, select the cell and choose "No Fill" from the paint bucket menu.
  • Conditional formatting lets you color cells automatically based on their values, useful for highlighting numbers above or below a threshold.

Accessing more color options

The paint bucket icon usually shows a small dropdown arrow next to it. Click that arrow to open the full color palette instead of explore the last color you used. A menu appears with rows of preset colors, including theme colors that match your spreadsheet's design.

At the bottom of the color menu, you'll see "More Colors" or a similar option. Click it to open a dialog where you can choose from thousands of colors, enter a specific color code (useful if your workplace uses brand colors), or adjust brightness and saturation. This is where you go if the preset palette doesn't have the shade you need.

Coloring entire rows or columns

To color a whole row, click the row number on the left side of the spreadsheet. The entire row highlights in blue, showing it's selected. Then click the paint bucket and choose your color—the whole row changes at once.

The same method works for columns: click the column letter at the top (A, B, C, and so on) to select the entire column, then explore color. This is faster than selecting individual cells if you want a consistent color across a whole section of your data.

Removing or changing cell colors

To remove a color you've already applied, select the colored cell or cells, click the paint bucket dropdown arrow, and choose "No Fill" at the bottom of the menu. The background returns to white (or whatever your spreadsheet's default is).

To change a color to a different one, just select the cell and click the paint bucket again. The new color replaces the old one—you don't have to remove the old color first.

Using conditional formatting for automatic coloring

If you want cells to change color based on what's in them—for example, turning red when a number drops below a certain value—use conditional formatting instead of manual coloring. This lives in the Home tab under "Conditional Formatting" (usually on the right side of the ribbon).

Conditional formatting is useful when your data changes often. You set a rule once (like "color this cell red if the value is less than 100"), and Excel applies it automatically to any cell that meets that condition. If the value changes later, the color updates without you having to do anything.

To set up a basic rule, select the cells you want to format, click Conditional Formatting, choose "Highlight Cell Rules," and pick a condition like "Greater Than" or "Less Than." Enter your threshold number, and Excel shows you a preview of the color before you confirm.

Coloring text versus cell backgrounds

The paint bucket colors the cell's background. If you want to color the text itself (the numbers or words inside the cell) instead, use the Font Color button, which usually sits right next to the paint bucket. It looks like an "A" with a colored bar underneath.

You can use both at once: color the background one color and the text a different color. This is useful for making important data stand out—for example, white text on a dark background, or red text on a light background.

Frequently Asked Questions

Can I color multiple non-adjacent cells at the same time?

Yes. Hold Ctrl (Cmd on Mac) and click each cell you want to color. They'll all highlight in blue. Then click the paint bucket and choose your color—all selected cells change at once, even though they're not next to each other.

What's the difference between fill color and conditional formatting?

Fill color is manual: you pick a cell and a color, and it stays that color until you change it. Conditional formatting is automatic: you set a rule based on the cell's value, and the color updates whenever the value changes. Use fill color for static highlighting; use conditional formatting when your data changes.

How do I match a specific brand color or hex code?

Click the paint bucket dropdown, select "More Colors," then look for a field labeled "Color Code" or similar. Paste your hex code (the six-character code like #FF5733) into that field, and Excel converts it to the exact color you need.

Can I undo a color change if I applied it by mistake?

Yes. Press Ctrl+Z (Cmd+Z on Mac) when ready after explore the color, and Excel removes it. You can undo multiple steps this way if you colored several cells and want to revert them all.

Does cell color affect printing?

By default, Excel prints cell colors as you see them on screen. If you want to print without colors to save ink, go to File > Print, look for a "Print Options" or "Settings" section, and choose an option like "Print without formatting" or "Grayscale" (the exact wording varies by Excel version).