Excel Cell Background Color: How to Change and Fix It

To change an Excel cell background color, select the cell or range, then choose Home > Font > Fill Color and pick a color. The background is called the cell fill; if a color seems to ignore your choice, check whether conditional formatting is controlling what appears.

What Excel Means by Cell Background Color

Excel’s background color is a formatting property called Fill Color. It paints the interior of a cell, behind its text, numbers, or formulas. It does not change the value stored in the cell, the font color, or the worksheet gridlines. For instance, filling B2 with pale yellow does not alter a date or formula in B2; it only changes how the cell is displayed.

A fill is different from a font color, which changes the characters, and from a border, which draws lines around a cell or range. Those options sit near one another in the Home tab’s Font group, so it is easy to choose the wrong one. The paint-bucket icon is Fill Color; the letter A with a colored underline is Font Color.

Fill color can be applied to one cell, a group of selected cells, or whole rows and columns. It is also separate from a table style and from conditional formatting, both of which can affect the color you see. Knowing which feature is responsible makes color changes easier to control.

Change a Cell’s Fill Color

In Excel for Microsoft 365 on Windows, select the target cell or range and use the Fill Color control on the Home tab. The main part of the paint-bucket button applies the most recently used color; its dropdown arrow opens the palette. If the button’s current color is not the one you want, use the arrow rather than clicking the main button.

Select a cell, a range, or multiple nonadjacent cells. To select nonadjacent cells on Windows, hold Ctrl while clicking each one.
Open Home > Font > Fill Color.
Choose a color from Theme Colors, Standard Colors, or Recent Colors. If you need a precise shade, choose More Colors and use the available color controls.

For example, select D2:D20 and choose a light blue fill to shade those cells. The fill applies to every selected cell. Clicking a color once applies it immediately; it does not open a dialog asking whether to apply the color to the whole selection.

To apply a fill to an entire row or column, select its row number or column letter before choosing the color. Use this sparingly in large sheets: broad blocks of color can make the data harder to scan and can increase the visual weight of a worksheet.

Choose a Color and Understand the Palette

Theme Colors are tied to the workbook’s current theme. A theme color can have lighter and darker variations, which makes it practical to use a pale shade for a background and a stronger related shade for emphasis. If the workbook theme changes, theme-based formatting can reflect the new theme. Standard Colors are more independent of theme choices, while Recent Colors offers quick access to colors used recently.

For a shade that is not in the palette, open More Colors. Depending on the dialog and version, you can specify a custom color using color values or select it visually. This is useful when matching a company color, but keep a note of the chosen values if consistency across workbooks matters. Excel does not provide a general transparency slider for ordinary cell fills, so a lighter shade—not partial transparency—is the usual way to create a softer background.

Pick colors for meaning as well as appearance. A subdued fill can distinguish input cells from calculated cells; a stronger color can flag an exception. Keep the same meaning consistent throughout the workbook. For example, if pale yellow marks cells a user should complete, using the same yellow for unrelated warnings may confuse readers.

Use Conditional Formatting for Changing Colors

Use a regular fill when the color should stay as you set it. Use conditional formatting when the color should respond to a value, date, or rule. For example, conditional formatting can shade overdue items, highlight values above a threshold, or show a color scale across a range. The formatting is applied when the rule is true, so the displayed color can change as the underlying data changes.

For built-in rules, select the cells and choose Home > Conditional Formatting > Highlight Cells Rules, then choose a rule such as Greater Than or Text that Contains. Set the condition, choose a format, and confirm it. Other rule types, including color scales, are available from the Conditional Formatting menu.

For a custom rule, suppose A2:C6 contains task names, owners, and status, with statuses in C2:C6. Select A2:C6, choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format, and enter =$C2="Overdue". Choose a fill in the format settings. The dollar sign fixes the status column while the row number adjusts, so each row is shaded across A:C when its column C value is Overdue. If C2 and C5 contain Overdue, rows 2 and 5 are shaded.

If a cell has both direct fill formatting and a conditional-format rule, the conditional format can determine the color displayed while its condition is true. To investigate, select the affected cells and open Home > Conditional Formatting > Manage Rules. Check which rules apply to the selection, their order, and any Stop If True setting. Removing or changing a rule may be the right fix; repeatedly applying a direct fill may not be.

Copy, Change, or Remove a Fill

To reuse a fill, copy a formatted cell and paste its formatting to another area. One way is to copy the source, select the destination, then use the Paste Options control and choose the formatting option. On Windows, Paste Special also offers Formats; the exact menu presentation can vary with the ribbon and Excel version. Format Painter on the Home tab is another option for copying a cell’s formatting, including its fill, font, and borders.

To remove a fill without removing other formatting, select the cells, open Home > Font > Fill Color, and choose No Fill. This is not the same as choosing white. A white fill is an actual color that covers the cell background; No Fill removes the fill property and allows the worksheet’s normal background to show through. This distinction can matter when a sheet has colored backgrounds or when formatting is being reused.

Home > Editing > Clear > Clear Formats removes formatting more broadly, including font, borders, number formats, and fills. Use that only when you intend to clear all those formats, not just the background color. If conditional formatting supplies the color, No Fill alone will not remove the rule; edit or delete the rule in Manage Rules instead.

Common Reasons a Color Will Not Change

When a cell keeps showing an unexpected color, identify the source before changing more formatting. These checks cover the most common causes:

Conditional formatting: A rule may be applying a different fill. Review the rules that apply to the selected cells in Manage Rules.
Wrong formatting control: Confirm that you used Fill Color, not Font Color or a border control.
Selection mismatch: Check that the intended cell or range is selected. Merged cells and large selections can make the affected area less obvious.
Table style: A formatted Excel table can display banded rows or other style effects. Check the table style and its options if the color pattern follows the table.
White versus No Fill: White is a fill color; No Fill removes the fill. Choose the one that matches the intended appearance.
Display or print settings: A color can look different on another screen or in print. Check the sheet on screen and use Print Preview before assuming the stored formatting is wrong.

If a workbook is shared, another person may also have changed its theme or rules. A cell’s visible appearance can be the combined effect of its direct formatting, conditional formatting, and table styling, rather than a single background setting.

Readability, Printing, and Sharing

Color should support the data, not carry essential meaning by itself. A red fill may be hard to distinguish for some readers, and colors can look different on monitors, projectors, and printed pages. Pair color with a clear label, symbol, or status value—for example, show the word Overdue as well as using a warning fill. Choose sufficient contrast between text and fill so that values remain legible.

Cell fills usually appear in printed worksheets, but print setup and printer capabilities can affect the result. Use File > Print to inspect Print Preview. In Page Setup, a Black and white option can change how a sheet prints. If a color looks pale or disappears, inspect those settings and the printer’s output options before redesigning the workbook. For files shared electronically, consider how the colors look in Excel for the web and on different displays.

On Mac and in Excel for the web, the basic task is also to select cells and use the Fill Color control on the Home ribbon. Ribbon layout, dialog details, and some keyboard commands vary by platform, so use the visible control rather than relying on a Windows-only shortcut. Conditional-formatting features and dialogs can also differ slightly across apps and versions.

Frequently Asked Questions

How do I change the background color of multiple Excel cells?

Select the range, then choose Home > Font > Fill Color and select a shade. The chosen fill applies to all selected cells. To select separate cells on Windows, hold Ctrl as you click them.

How do I remove a cell background color without clearing everything?

Select the cells and choose Home > Font > Fill Color > No Fill. Avoid Clear Formats if you want to preserve number formats, borders, and fonts. If a conditional-formatting rule creates the color, remove or edit that rule instead.

Why does Excel keep changing my cell color?

A conditional-formatting rule may be changing the displayed fill when cell values change. Table styles can also create recurring color patterns. Check Home > Conditional Formatting > Manage Rules and inspect the table’s style if the color follows its rows or columns.

Is white fill the same as No Fill in Excel?

No. White is an applied fill color; No Fill removes the fill formatting. On a plain white worksheet they may look identical, but they behave differently when the cell background or formatting context changes.

Can Excel change a cell’s color automatically based on its value?

Yes. Select the relevant cells and use Home > Conditional Formatting to create a built-in or custom rule. The fill is displayed when the rule’s condition is met, and can change as the cell values change.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.