To copy just a cell’s fill color in Excel, select the destination cell, open Home > Fill Color, and choose the same color as the source. This changes the background only; it leaves the destination’s font, borders, alignment, and number format alone. For a custom color, read or match its RGB values through Format Cells. Avoid Format Painter if you need to preserve the destination’s other formatting, because it copies more than the fill.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The cell with the fill color you want to reuse, and the cell or range that should receive it.
- If the color is custom and you need an exact match, access to the source color’s RGB values, or the ability to identify the same color in the Fill palette.
You do not need to copy or paste the source cell. Keeping the source and destination visible at the same time makes matching easier, but it is not essential. If the source color comes from conditional formatting rather than a manually applied fill, see the troubleshooting section: the displayed color may not be the cell’s ordinary fill color.
Step-by-Step
- Identify the source and destination. Click the cell whose background color you want to reproduce, then note its color and location. Click the destination cell only when you are ready to apply the color. If you want to color several nonadjacent cells, you can apply the color to each one in turn; for a continuous block, select the whole destination range before choosing the fill. Take care not to include the source cell in that range unless you intend to change it too.
- Check the source color in the Fill controls. With the source selected, go to Home and find the Font group. The paint-bucket button is Fill Color; its small arrow opens the color menu. The button itself applies the currently shown color, so do not click the main part of the button yet if you are unsure which color it will apply. Open the arrow to view the Theme Colors, Standard Colors, and any available recent or custom colors.
- Match a theme or standard color. If the source uses a color visible in the palette, select the destination cell, open Home > Fill Color, and click the matching swatch. Theme colors are arranged in a row with lighter and darker variations; choose the same position and shade, not simply a color that looks similar. Standard colors appear separately. Excel applies the selected fill without copying other cell formatting. If the destination is a range, select that range first and then apply the swatch once.
- Use RGB values for a custom color. If a palette swatch is not an exact match, select the source cell and press Ctrl+1 to open Format Cells. Choose the Fill tab and open More Colors. If the color dialog shows the selected color’s RGB fields, write down the Red, Green, and Blue numbers. Close the dialog without changing the source. Select the destination, reopen Ctrl+1 > Fill > More Colors, enter those same three numbers on the Custom tab, and confirm with OK. This applies the same RGB color while leaving other formatting properties untouched.
- Confirm the result. Compare the destination with the source, preferably side by side and at the same zoom level. If the color appears right, check that the destination’s font, borders, number format, and alignment have not changed. You can also select the destination and open Ctrl+1 > Fill to inspect its fill setting. If the source is a theme color with a tint, matching its theme swatch and tint is preferable to choosing a close-looking shade. If you used RGB, confirm the numbers match.
Mac and web notes: In Excel for Mac, use Home > Fill Color to choose the swatch; Command+1 opens Format Cells in current desktop versions. The color dialog’s labels and layout can differ slightly from Windows. In Excel for the web, use Home > Fill Color and choose a palette color. The web interface may not expose the same RGB fields as desktop Excel, so for a precise custom color, open the workbook in the desktop app if those fields are unavailable.
Common Mistakes
- Using Format Painter for a color-only job. Format Painter copies a bundle of formatting, which can include the font, borders, alignment, and number format. It is useful when you want the whole appearance, but not when the destination must retain its existing settings. Choose the fill swatch directly instead.
- Using Paste Special > Formats and expecting only the fill. This pastes cell formatting as a group, not just the background color. It may overwrite formatting you wanted to keep. Use it only if copying all relevant formatting is acceptable.
- Choosing a similar-looking shade rather than the same one. Two neighboring theme shades can look alike on screen but have different color values. This becomes especially noticeable when cells are printed, viewed on another monitor, or placed next to each other. Match the same palette position or use RGB values.
- Clicking the paint-bucket button instead of its arrow. The main button applies its current color immediately. If it is showing a different color from the source, the destination gets that wrong color. Open the arrow to pick the intended swatch.
- Confusing a conditional-formatting color with a normal fill. A cell can look colored because a rule is active, even though its ordinary Fill setting is different or empty. Copying a palette color that resembles what you see may not reproduce the rule’s behavior.
Tips
- Keep the destination selected carefully. Before applying the color, check the Name Box to confirm the active cell or range. This is helpful when the sheet is large or the destination is off-screen.
- Use a nearby sample when colors are subtle. If the source is visible, place the destination next to it temporarily or compare them at the same zoom. Screen brightness, display settings, and conditional formatting can make a correct color seem different.
- Record a brand color’s RGB values. If you reuse a custom fill across several sheets, keep its RGB numbers in a note or a small reference table. That is more reliable than trying to remember which custom swatch you selected.
- Use the theme palette when the workbook has a theme. A theme color can change when the workbook theme changes. Choosing the same theme swatch and tint keeps the fill connected to that theme; an RGB color stays a fixed color instead.
- Undo promptly if you apply the wrong fill. Press Ctrl+Z on Windows or Command+Z on Mac to undo the last change, then select the destination again and choose the correct color. If you made several changes after the fill, check the undo list before reversing more than intended.
Troubleshooting
The destination color looks different from the source. First check that you selected the same swatch and, for theme colors, the same tint. If the source uses a custom color, compare RGB values rather than judging by appearance. Also check whether the source cell is conditionally formatted: select it and open Home > Conditional Formatting > Manage Rules to inspect rules affecting the cell. The visible fill may be produced by a rule, not by the ordinary Fill setting. If so, copying the underlying fill alone will not copy the displayed result.
I cannot find the exact color in the palette. Open Format Cells for the source with Ctrl+1, choose Fill, and look under More Colors for the color values. If Excel does not show usable RGB values for that selection, the source may use a theme color or tint. Match the theme swatch and tint, or use desktop Excel to inspect the color more closely. Excel for the web may have fewer color-inspection controls than the desktop app.
The destination’s font or borders changed too. You likely used Format Painter, Paste Special formatting, or another broad formatting command. Press Ctrl+Z on Windows or Command+Z on Mac immediately, if the change is still the latest action. Then reapply the fill using Home > Fill Color or the Fill tab in Format Cells. If undo is no longer available, restore the destination’s affected formatting manually or use a known-good copy of the workbook.
The color did not appear at all. Confirm that the sheet is not protected against formatting changes and that you selected the intended cell. Check for conditional formatting that may be overriding the visible fill. If you are applying a fill to cells with a table style, the table’s banding or style can make the result appear unexpected; inspect the cell’s Fill setting and the table style separately. Also make sure the fill color is not set to No Color or the same color as the cell background.
Frequently Asked Questions
Can I copy only the fill color with Format Painter?
No. Format Painter copies broader formatting, not just the fill. To preserve the destination’s other settings, use the Fill Color palette or enter the source color through Format Cells > Fill.
Does Paste Special have a fill-color-only option?
Not in the standard Paste Special options in Excel for Microsoft 365. The Formats option copies multiple formatting properties, so it is not the right choice when only the fill should change.
Will this work for several cells at once?
Yes. Select a contiguous destination range, then choose the fill color once. For nonadjacent cells, select each destination separately and apply the same swatch, or use Ctrl-click on Windows to select multiple cells before applying it. Check your selection first so you do not recolor cells unintentionally.
Can I copy a fill color from a cell with conditional formatting?
You can apply a similar ordinary fill manually, but that does not copy the conditional-formatting rule or its changing behavior. If you want the destination to respond to the same conditions, copy or recreate the relevant rule through Home > Conditional Formatting instead.
Will an RGB fill stay the same if I change the workbook theme?
A manually entered RGB color is a fixed color and generally remains that color when the theme changes. A theme-linked fill can change with the workbook theme. Use the same theme swatch and tint when you want the color to follow the theme.
Related
- How to Close Microsoft Excel Without Losing Work
- Close Multiple Windows in Excel: Keep Workbooks Open
- How to Close Excel Without Saving Changes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Remove Formatting in Word: Keyboard Shortcuts ExplainedIn Microsoft Word for Windows, press Ctrl+Spacebar to remove direct character formatting, such as manually applied bold or…
- Create a Signature in Outlook Web App: Step-by-StepTo create a signature in Outlook on the web, open Settings, go to the signature settings, write and…
- Excel Goal Seek May Not Find a Solution: What to DoWhen Excel says Goal Seek may not have found a solution, it means the calculation did not reach…
- How to Add a Cover Page in Word and Customize It EasilyIn Word for Microsoft 365 on Windows, place the cursor in your document, select Insert > Pages >…
- How to Add a New Header Section in Microsoft WordTo give part of a Word document its own header, place a section break where the new header…
- Clear Outlook Cache With Run: Safe Windows StepsTo clear a specific Outlook cache in classic Outlook for Windows, press Windows key + R, enter %localappdata%\Microsoft\Outlook\RoamCache,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.