To change a cell’s background color in Excel for Microsoft 365 on Windows, select the cell or range, then choose Home > Fill Color ▼ and click a color. Use the arrow beside the paint-bucket icon to open the palette; clicking the icon itself applies the currently displayed color. You can change one cell, several selected cells, or a whole range without changing the text inside.
Cell color is often called fill color. It can make headings, totals, input areas, or important values easier to spot. Before you begin, decide whether you want a single consistent color or a rule-based color that changes when a value changes. The steps below cover ordinary fill colors first, then explain what to do if a color is hidden or needs to update automatically.
What You’ll Need
- A workbook open in Excel for Microsoft 365, Excel 2021, or a recent desktop version of Excel.
- Permission to edit the worksheet. If it is protected, you may need the password or help from the workbook owner.
- A color choice. Excel offers theme and standard colors, and you can create a custom color when the built-in choices do not suit your sheet.
You do not need to install an add-in or use a formula for a basic cell fill. If you are using Excel for the web, the main steps are similar, though some advanced color controls may look or behave differently.
Step-by-Step
-
Open the worksheet and locate the cells. Click the sheet tab that contains the cells you want to format. If the workbook has several sheets, confirm that you are on the right one before applying a fill. Select the target cell, or plan the range you want to format together. For example, if you are highlighting the heading row, select the heading cells rather than the entire worksheet.
-
Select one cell or a range. Click a single cell to color it. To select adjacent cells, click the first cell and drag across the others, or click the first cell, hold Shift, and click the last cell. You can also click the Name Box to the left of the formula bar, type a range such as B2:F2, and press Enter. To select separate, nonadjacent cells in Windows, hold Ctrl while clicking each cell or range. On Mac, use Command while selecting separate areas.
-
Open the Fill Color palette. On the ribbon, select the Home tab. In the Font group, find the paint-bucket-shaped Fill Color control. Click the small arrow beside it to display the color palette. Be careful to use Fill Color, which changes the cell background, rather than Font Color, which changes the lettering. If the ribbon is minimized, select Home or expand the ribbon so you can see the controls.
-
Choose a color. Click a color in Theme Colors or Standard Colors. Theme Colors are coordinated with the workbook’s theme and may include lighter and darker variations. Standard Colors are basic choices that are less tied to the theme. As you point to colors in the desktop palette, Excel may preview the fill on the selected cells; click to apply the shade you want. The selection remains in place, so you can compare the result with nearby cells.
-
Apply a custom shade if needed. Open the Fill Color arrow and choose More Colors. In the color dialog, use the Standard tab for additional choices or the Custom tab to specify a color using its RGB values. Enter the red, green, and blue values, then confirm with OK. Custom shades are useful when matching a chart, a company palette, or an existing color in a workbook. If you do not know the RGB values, choose a similar theme color rather than guessing at a precise match.
-
Check the result and adjust the text if necessary. Click outside the selection to see the cells in context. If the fill makes the text difficult to read, change the text color using Home > Font Color, or choose a lighter or darker fill. For headings, use a contrast that remains legible on screen and when printed. A color should support the information, not make the cell’s contents hard to identify.
-
Remove a fill when you no longer need it. Select the cell or range, open Home > Fill Color ▼, and choose No Fill. This clears the cell background fill without deleting its contents or changing its number format. If your goal is to restore all formatting to Excel’s default, use Home > Clear > Clear Formats instead, but note that this also removes other formatting such as bold text, borders, and number formats.
-
Use the same color elsewhere, if appropriate. Select a cell that already has the fill you want, choose Home > Format Painter, and then click or drag over the destination cells. Format Painter copies formatting, not just the fill, so it may also copy borders, font settings, and number formats. If you only want the background color, use the Fill Color palette on the new selection instead.
On Excel for Mac, select the cells and use Home > Fill Color, then choose a swatch from the palette. Ribbon names and placement are broadly similar, although the layout can differ by window size and Excel version. On Excel for the web, select the cells, open Home, and use the Fill Color control. Some desktop color-dialog options may not be available in the same form in the browser. If you cannot find a control, widen the Excel window or look in the ribbon’s overflow menus.
In Windows desktop Excel, you can also open the Fill Color palette with the keyboard sequence Alt, H, H. Press the keys in order rather than holding all three at once, then use the arrow keys to choose a color and press Enter. Keyboard sequences can vary with ribbon layout and localization, so use the on-screen arrow if that sequence does not open the palette. Mac users can use the ribbon; there is not one equivalent fill-palette shortcut that works consistently across Mac versions.
Common Mistakes
-
Clicking the paint bucket instead of its arrow. The main Fill Color button applies the last-used color immediately. If it seems as though Excel is not offering choices, click the small arrow next to the bucket.
-
Changing Font Color instead of Fill Color. The two controls are near each other in the Home tab. Font Color affects the characters; Fill Color affects the cell background. If the letters changed but the cell did not, undo with Ctrl+Z on Windows or Command+Z on Mac, then choose the correct control.
-
Selecting the wrong cells. A fill applies to every selected cell, including any cells you did not mean to include. Check the highlighted selection outline before choosing a color. If the range is large, use the Name Box to specify it clearly.
-
Using Clear All when you only want to remove the color. Clear All can remove contents and formatting. Choose No Fill to remove only the background fill. Choose Clear Formats only when you intend to remove other formatting as well.
-
Assuming the color itself communicates the whole message. A reader may print the sheet in grayscale, have color-vision differences, or view it on a screen with different contrast. Pair color with a label, symbol, border, or clear heading when the distinction matters.
Tips
-
Use a small, consistent palette. Assign a few colors to predictable purposes, such as one for headings and another for cells where users should enter information. Reusing colors makes a worksheet easier to scan than giving every section a different shade.
-
Use theme colors for workbooks that may be redesigned. Theme colors can change together when the workbook theme changes. A custom RGB color is more appropriate when you need to match a specific shade, but it will not automatically follow theme changes.
-
Apply a fill to a whole range at once. Select the range before opening the palette instead of repeating the action cell by cell. This keeps a heading row or input area visually consistent and takes fewer clicks.
-
Keep important text readable. Dark fills usually need light text, while pale fills usually work with dark text. Check the result at normal zoom and consider how it will look if printed. Avoid very saturated backgrounds behind long blocks of text.
-
Consider conditional formatting for changing values. A manual fill stays the same until someone changes it. If a cell should turn red when a value is overdue, or green when it meets a target, use Home > Conditional Formatting and create a rule. Conditional formatting is better for values that change because Excel can update the appearance automatically.
Troubleshooting
The fill color does not appear after you choose it. First confirm that you selected the intended cells and chose Fill Color rather than Font Color. If the cells still look unchanged, check whether conditional formatting is applying another fill. Select an affected cell and choose Home > Conditional Formatting > Manage Rules. Review the rules that apply to the selected cells or the worksheet, and edit, reorder, or remove the rule if appropriate. A conditional formatting rule can take precedence over a manually applied fill while its condition is true.
The cells change color when values change, or the color returns later. This usually indicates conditional formatting rather than an ordinary fill. Use Home > Conditional Formatting > Manage Rules to inspect the applicable rules. In the Manage Rules window, check the Show formatting rules for setting so you are viewing the relevant selection or worksheet. Edit the rule if the automatic behavior is intended; delete it only if you are sure the worksheet no longer needs that behavior.
You cannot format the cells. The worksheet may be protected. Check the Review tab for Unprotect Sheet. If unprotecting requires a password, ask the workbook owner rather than trying to bypass the protection. A shared or read-only workbook may also limit changes or prevent you from saving them. If you can make edits but cannot keep them, use File > Save As to create a copy where you have permission, if your workplace or file owner allows it.
The color looks different from the swatch. Theme colors can depend on the workbook theme, and screen brightness, display settings, and nearby colors affect how a shade appears. Select the cell and reopen More Colors if you need to check its RGB values. If the workbook will be printed, use Print Preview to see whether the contrast remains clear on paper. Do not rely on a subtle shade difference to convey a critical status.
The ribbon control is missing or hard to find. Make sure the Home tab is selected and look in the Font group. If Excel’s window is narrow, some controls may be compressed or placed in a menu. Maximize the window or expand the ribbon. In the web version, the command may be presented in a compact ribbon, but it is still called Fill Color.
You colored too many cells by mistake. Press Ctrl+Z on Windows or Command+Z on Mac immediately after the action, then select the correct range and apply the fill again. If other actions have happened since, undo may reverse those too. You can also select the unintended cells and choose No Fill, taking care not to remove formatting that should remain.
Frequently Asked Questions
How do I change the color of just one cell?
Select the cell, choose Home > Fill Color ▼, and click a swatch. The fill changes only that cell unless other cells are also selected.
Can I color several cells at once?
Yes. Select a contiguous range by dragging or using Shift-click, then choose a fill color. For separate cells, hold Ctrl while selecting them in Windows or Command on Mac, then apply the color once.
How do I change a cell back to white?
If you want no background fill, choose Home > Fill Color ▼ > No Fill. White is a specific fill color; it can cover gridlines on screen, so No Fill is usually the better choice when restoring the ordinary worksheet background.
Can a cell change color automatically based on its value?
Yes. Use Home > Conditional Formatting to make a rule based on a value, text, date, or formula. A manual Fill Color choice does not update automatically when the cell’s contents change.
Will changing a cell’s fill color change its value or formula?
No. Applying or removing a fill changes appearance only. The cell’s contents, formula, and number format remain unchanged unless you choose a command such as Clear Formats or edit the cell itself.
Does the same process work in Excel for the web?
Yes. Select the cell or range, open the Home tab, and choose Fill Color. The palette may have fewer or differently arranged options than desktop Excel, so use the desktop app if you need a particular advanced custom-color control.
Related
- How to Align Names in Excel: Cells and Lists
- How to Align an Image in an Excel Cell and Keep It in Place
- How to Align Cell Size in Excel for a Neater Sheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Power Query in Google Sheets: What You Can Do InsteadNo—Google Sheets does not include Microsoft Excel’s Power Query editor, and it cannot run Power Query’s M language…
- Excel Conditional Formatting: How to Test Rules EasilyTo test conditional formatting in Excel for Microsoft 365 on Windows, create a small set of sample values,…
- Currency Exchange in Google Sheets: Rates and FormulasTo get a currency exchange rate in Google Sheets, enter a formula such as =GOOGLEFINANCE("CURRENCY:USDEUR"), which requests the…
- COUNTIF in Google Sheets: Syntax, Examples, and TipsIn Google Sheets, COUNTIF counts cells that meet one condition. If A2:A6 contains Maya, Leo, Maya, Noor, and…
- Excel Data Validation Lists: Create and Manage DropdownsIn Excel for Microsoft 365 on Windows, create a dropdown by selecting the cells, choosing Data > Data…
- How to Delete a Blank Page in Word Without Losing TextTo delete a blank page in Word, turn on formatting marks with Ctrl+Shift+8 on Windows or Command+8 on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.