Excel Cell Highlight Color: How to Change It

To change a cell’s highlight color in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home > Font > Fill Color and pick a color. The paint-bucket button applies its displayed color; select the arrow beside it to choose another shade. This changes the cell fill, not the text color.

What Excel Means by Cell Highlight Color

Excel calls a cell’s background its fill color. People often call it highlighting because it makes an entry stand out, marks a status, or separates one part of a worksheet from another. The fill is formatting: it changes how a cell looks without changing the value, formula, or data stored in it.

That distinction matters when a cell appears colored for a reason other than a manually applied fill. A cell may be colored by a conditional formatting rule, a table style, or a selected-cell indicator. Those features have different controls, so changing the regular Fill Color may not produce the result you expect.

Change a Cell or Range’s Fill Color

For a standard, manually applied color, use the ribbon:

Select one cell, or drag across the cells you want to format. To select several separate cells or ranges, hold Ctrl while selecting them.
Open the Home tab and find the Font group.
Select the arrow next to Fill Color, shown as a paint bucket, and choose a color from the palette.

If you click the main paint-bucket button rather than its arrow, Excel applies the color currently shown on the button. That is useful for applying the same color repeatedly. If the chosen shade is difficult to read or does not fit the workbook, reopen the palette and select another one.

To remove a manually applied fill, select the cells and choose Home > Font > Fill Color > No Fill. No Fill makes the cells transparent to the worksheet background; it does not change their contents. Gridlines may show through afterward, depending on the sheet’s gridline setting.

Choose a Theme Color or Custom Shade

The Fill Color palette includes theme colors, their lighter and darker variations, and standard colors. Theme colors are connected to the workbook’s theme. Choosing one helps keep related formatting consistent and can make it easier to update a workbook’s overall color scheme later. Standard colors are convenient for a quick choice that does not depend on the theme.

For a more specific color, open the Fill Color palette and choose More Colors. In the desktop Excel color dialog, use the custom color controls, including RGB values, when an exact match is important. For example, a team can specify the same RGB color for all status cells rather than relying on an approximate visual match. The available controls can vary with the Excel version and platform.

Use a restrained palette. A light fill is usually easier to read behind dark text, while a deep fill may require a contrasting font color. Color should support meaning, not carry it alone: use a label such as Open or Complete as well as a color so that readers can understand the sheet when printed in grayscale or viewed by someone with color-vision differences.

Use a Keyboard Shortcut

In Excel desktop for Windows, select the cells and press Alt+H, H to open the Fill Color palette. This is a sequence: press Alt and H, release them, then press H. Use the arrow keys to move through available choices and press Enter to apply the selected color. Keyboard access can be useful when formatting many cells or when working without a mouse.

There is not a single identical fill-color shortcut that works across Windows, Mac, and Excel for the web. On a Mac, use the ribbon’s Fill Color control or the keyboard navigation available in that version of Excel; shortcuts can differ by keyboard layout and release. In the web app, use Home and the Fill Color control, or consult the Key Tips shown for the current interface rather than assuming a Windows sequence will work.

Change Colors Automatically with Conditional Formatting

If a cell’s color should depend on its value, use conditional formatting instead of manually recoloring it. For example, a task list might show overdue dates in red and completed items in green. Excel applies the formatting when a rule is true, and updates it as values change.

Select the relevant cells, then choose Home > Conditional Formatting and select a suitable rule, such as Highlight Cells Rules for values that meet a condition. For more control, choose New Rule, set the condition, select Format, and choose a fill on the Fill tab. The options presented depend on the rule type.

Conditional formatting can take precedence visually over a regular fill. If a cell appears to ignore a fill color you just chose, inspect its rules using Home > Conditional Formatting > Manage Rules. In the manager, check the rules that apply to the selected cells, their ranges, order, and formatting. Edit or remove a rule only if its behavior is no longer wanted; deleting it changes the automatic formatting for every cell it affects.

Use manual fills for stable labels or one-time emphasis, such as shading a heading. Use conditional formatting for changing conditions, such as values below a target. Applying both is possible, but it can make the final appearance confusing because the rule may cover the manually chosen color.

Why a Cell’s Color May Not Change

When a fill choice does not appear, first identify what is drawing the color. A conditional formatting rule is a frequent cause. A formatted Excel table is another: its banded rows or header colors can come from the table style, and changing the style may be more appropriate than manually filling individual cells. Select a cell and check the relevant ribbon options before changing a large range.

Other common explanations include selecting the wrong cells, choosing a font color rather than a fill, or applying the currently displayed paint-bucket color by clicking the main button. If the cell looks blank after choosing No Fill, the worksheet’s gridlines may be hidden, or the sheet background may be white. Gridlines are not cell fills and do not print as ordinary cell borders.

Try these checks in order:

Confirm that the intended cell or range is selected.
Use the arrow beside Fill Color and choose a visibly different shade to verify the control.
Check Conditional Formatting rules for the range.
Check whether the cells are part of a formatted table.
Look at the sheet in another view or print preview if the difference is only visible on screen.

If the workbook is protected, formatting cells may be restricted. The workbook owner may need to allow cell formatting or remove protection before you can make the change. Protection settings depend on how the workbook was configured.

Copy, Reuse, or Clear Cell Formatting

To apply an existing cell’s appearance elsewhere, select the source cell, choose Home > Clipboard > Format Painter, then select the destination cell or range. Double-click Format Painter to apply the formatting to multiple destinations; press Esc when finished. Format Painter can copy more than fill color, including number formats, borders, and font formatting, so check the destination if you only intended to copy one visual detail.

For a one-off transfer, copy the source cell, select the destination, and use the paste options to paste formatting. The exact paste menu can depend on the version and platform. If you need to remove all formatting rather than just a fill, use Home > Editing > Clear > Clear Formats carefully: that can remove other formatting, such as borders and number formats, not just the background color. To remove only a manual fill, use No Fill instead.

Excel for Mac and Excel for the Web

The basic method is similar across Excel versions: select the cells, open the Home tab, and use Fill Color. On a Mac, the ribbon location and palette are familiar, but keyboard shortcuts and some dialog details differ from Windows. If a Windows shortcut does not work, use the visible ribbon control rather than assuming the shortcut is universal.

Excel for the web also provides fill formatting from the Home tab. Its interface may arrange controls differently, and some advanced options can differ from the desktop app. If you cannot find a particular custom-color or rule-management control in the browser, open the workbook in the desktop application when available. Avoid making a decision based only on a menu label from a different platform; check the current version’s ribbon and dialogs.

Print and Accessibility Considerations

A cell fill is usually part of the workbook’s printed formatting, but printed colors may look different from screen colors because of printer settings, paper, and color mode. Review Print Preview before distributing a color-coded report. If the distinction is important, add text labels, symbols, or borders so the information remains understandable without color.

For readability, check contrast between the fill and the text, especially for small text and dense tables. A pale background with dark text is often a practical choice. Do not use many nearly identical shades to represent important categories: readers may struggle to distinguish them, and the distinctions can disappear in a grayscale printout.

Frequently Asked Questions

How do I change the highlight color in Excel?
Select the cells, then choose Home > Font > Fill Color. Select the arrow beside the paint-bucket button to choose a new color.

How do I remove the color from an Excel cell?
Select the cell and choose Home > Font > Fill Color > No Fill. If the color remains, check for conditional formatting or a table style.

Can Excel change a cell color automatically based on its value?
Yes. Create a rule from Home > Conditional Formatting. Choose a built-in rule or New Rule, define the condition, and set the fill in the formatting options.

Why does Excel keep changing my cell color back?
A conditional formatting rule may be applying its own fill when the cell value meets a condition. Review Home > Conditional Formatting > Manage Rules and edit the rule or its range if needed.

Does changing a cell’s fill color change its text color?
No. Fill Color changes the cell background. To change the text, select the cells and use the Font Color control in the Home tab’s Font group.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.