To color a cell in Excel, select it, go to the Home tab, click the arrow next to Fill Color (the paint bucket), and pick a color. You can also press Alt+H, H to open the same menu. To remove the color, open that menu again and choose No Fill.
These steps cover Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016 on Windows, which Microsoft lists for its articles on adding or changing the background color of cells and applying or removing cell shading. Excel for Mac and Excel for the web use the same Fill Color button, with differences noted in their own section below. The guide also draws on Microsoft’s pages on cell styles and conditional formatting.
Which Method to Use
| You want to | Use |
|---|---|
| Color a few cells once | Fill Color on the Home tab |
| Match an exact brand or report color | More Colors |
| Copy one cell’s color to other cells | Format Painter |
| Color every cell that contains a certain value | Find and Replace with a format |
| Color cells that change when the values change | Conditional formatting |
| Shade every other row | Format as Table or a MOD formula rule |
| Apply a ready-made look in one click | Cell Styles |
A fill you apply by hand stays until you remove it. A conditional formatting rule recolors cells on its own as the data changes. Keep that difference in mind when you pick a method.
How to Fill a Cell With Color in Excel
- Select the cell or range of cells you want to color. To select cells that are not next to each other, hold Ctrl and click each one.
- Go to the Home tab.
- Click the arrow next to Fill Color in the Font group, or press Alt+H, H. A palette opens.
- Pick a color under Theme Colors or Standard Colors. In current versions you can point at a color to preview it on the selected cells before you click.
The selected cells fill with that color. You can then click the Fill Color button itself, not its arrow, to apply the most recently used color to other cells.

If you colored the wrong cells, press Ctrl+Z right away to undo the fill.
Need a total for one of these fill colors? Read about counting colored cells in Excel, which explains Filter by Color with SUBTOTAL and when to count the condition behind a formatting rule.
How to Color Cells From the Right-Click Menu
- Select the cells.
- Right-click the selection. A small formatting toolbar appears above the shortcut menu.
- Click the arrow next to the paint bucket on that toolbar.
- Pick a color.
This is handy when the Home tab is not showing, for example when you are working on another ribbon tab.
How to Use a Custom Color
- Select the cells.
- Click the arrow next to Fill Color.
- Choose More Colors.
- On the Standard tab, click a color, or open the Custom tab to enter exact values, such as RGB numbers from a company style guide.
- Click OK.
The custom color is applied. Excel keeps up to 10 of your most recently selected custom colors under Recent Colors in the Fill Color menu, so you can reuse them without typing the values again.
Theme colors change if someone applies a different workbook theme on the Page Layout tab. Standard and custom colors stay the same, so use them when a color must not change.
How to Color a Whole Row or Column
Coloring a whole row or column changes the background of every cell in it, all the way across or down the sheet:
- Click the row number at the left or the column letter at the top to select the whole row or column. To color only part of a table, select that range instead.
- On the Home tab, click the arrow next to Fill Color.
- Pick a color that keeps the text easy to read.
- To remove it, select the row or column again and choose No Fill.
If a cell still shows a different color, a conditional formatting rule or table style is probably applying it. Check those before you change the fill again.
How to Color the Whole Sheet
Click the Select All button in the top-left corner of the sheet, where the row and column headings meet, or press Ctrl+A, then pick a fill color. This hides the gridlines. To keep the sheet easy to read, select the whole sheet, click the arrow next to Borders on the Home tab, and choose All Borders.
For a heavier line under a header row, add a thicker bottom border in Excel.
How to Fill Cells With a Pattern or Gradient
- Select the cells.
- Press Ctrl+Shift+F, or click the dialog box launcher in the corner of the Font group, to open Format Cells. Ctrl+1 also opens Format Cells.
- Click the Fill tab and choose a Background Color.
- For a two-color pattern, pick a Pattern Color and a Pattern Style. For a gradient, click Fill Effects instead and set the two colors and shading style on the Gradient tab.
- Check the Sample box at the bottom of the dialog, which previews your choice.
- Click OK.
The cells show the pattern or gradient. Use patterns sparingly, since dense patterns make numbers hard to read on screen and on paper.
How to Copy a Cell’s Color With Format Painter
- Click a cell that already has the color you want.
- On the Home tab, in the Clipboard group, click Format Painter. The pointer changes to a paintbrush.
- Drag across the cells you want to color, then let go of the mouse button.
Format Painter copies all of the cell’s formatting, including font, borders, and number format, not just the fill. To paint several separate ranges, double-click Format Painter instead of clicking it once, paint each range, and press Esc when you are done. Microsoft covers the basics in Copy cell formatting.
How to Color Every Cell That Contains a Value
Find and Replace can apply a fill color to every cell that holds the same text or number, such as every “Paid” in a status column.
- Select the range to search, or click one cell to search the whole sheet.
- Press Ctrl+H, or go to Home > Find & Select > Replace.
- Click Options to show the full dialog box.
- Type the value in Find what, and type the same value in Replace with so the content does not change.
- Click the Format button on the Replace with row, open the Fill tab, pick a color, and click OK.

- Click Replace All.
Every matching cell gets the color. This is a one-time change, so new “Paid” entries you type later are not colored. If you need that, use conditional formatting instead. Microsoft’s Find or replace text and numbers on a worksheet page covers the dialog in full.

How to Color Cells With a Cell Style
A cell style applies a saved set of formatting, including cell shading, in one step. To apply one, select the cells, then on the Home tab, in the Styles group, click the Cell Styles dropdown arrow and choose a style. Styles such as Good, Bad, and Neutral pair a fill with a matching font color.
To take a style back off, open the same gallery and choose Normal under Good, Bad and Neutral. Cell styles follow the workbook’s theme, so they change if you switch themes.
How to Color Cells Automatically Based on Their Values
- Select the cells.
- On the Home tab, click the arrow next to Conditional Formatting.
- Choose Highlight Cells Rules and pick a rule, such as Greater Than, Between, Equal To, or Text that Contains.
- Enter the value you want to use, then select a format, or choose Custom Format and pick a color on the Fill tab.
- Click OK.
Cells that meet the rule are colored, and the color updates when the values change. Microsoft also describes a shortcut: select your data and click the Quick Analysis button that appears at the lower-right corner, or press Ctrl+Q, then choose an option on the Formatting tab.
The same menu has two other ways to color by value. Color Scales shade each cell along a range of colors, such as green for high numbers and red for low ones. Data Bars draw a colored bar inside each cell whose length matches the value. To review or delete rules later, go to Conditional Formatting > Manage Rules.
For a custom condition or a whole row colored from one cell, you can use IF formulas to color cells in Excel. That article explains formula rules, dollar signs in cell references, and combining conditions. Conditional formatting can also highlight duplicate values before you remove duplicates.
You can put these colors to work in a Christmas list spreadsheet in Excel that marks gifts as bought or wrapped.
Our full guide to conditional formatting in Excel covers every rule type, formula rules, and how to edit or remove a rule.
How to Shade Every Other Row
Microsoft’s guide to shading alternate rows gives two ways.
With a table style:
- Select the range.
- Go to Home > Format as Table and pick a style under Light, Medium, or Dark.
- Click OK. Banded Rows is on by default, and the shading extends when you add rows.

To keep the colors but drop the table features, click a cell in the table and choose Table Design > Convert to Range. The banding then no longer extends to new rows.
With a formula rule:
- Select the range.
- Go to Home > Conditional Formatting > New Rule.
- Choose Use a formula to determine which cells to format.
- Enter =MOD(ROW(),2)=0 to shade even-numbered rows. Use =MOD(COLUMN(),2)=0 for alternate columns.
- Click Format, pick a color on the Fill tab, and click OK twice.
Coloring Cells in Excel for Mac and Excel for the Web
Excel for Mac: Select the cells, go to the Home tab, and click the arrow next to Fill Color. For patterns and gradients, press Command+1 to open Format Cells and use the Fill tab. The Alt+H key sequence is a Windows feature and does not work on a Mac.
Excel for the web: Select the cells and use Fill Color on the Home tab, which offers theme colors, standard colors, and No Fill. Microsoft’s background color article has a separate Web tab for this version. Pattern and gradient options from the desktop Format Cells dialog may not be offered in the browser, so open the file in the desktop app with Editing > Open in Desktop App if you need them.
If you also use Google Sheets, its fill color tool works differently, so read about adding or removing fill color in Google Sheets.
How to Remove Cell Color
- Select the colored cells.
- Click the arrow next to Fill Color.
- Choose No Fill.
No Fill removes background colors, patterns, and fill effects from the selected cells. It does not touch the values, fonts, or borders. If the color stays, it comes from a conditional formatting rule or a table style, which are covered in Troubleshooting below.
Reusing a colored worksheet? Here’s how to clear the cell data while keeping its formatting.
Pick Colors People Can Read
- Use light fills behind dark text. A dark fill needs white or very light text, which you set with Font Color (the letter A with a colored bar) next to Fill Color.
- Keep one meaning per color across the workbook, such as green for done and yellow for waiting.
- Do not let color carry the meaning alone. Readers with color vision differences, and anyone printing in black and white, may not see it. Add a status word or symbol in a cell as well.
Why Colored Cells Don’t Print in Color
Cell colors won’t print if Black and white or Draft quality is turned on, and Excel can turn on draft quality by itself for large or complex sheets. Go to Page Layout, click the Page Setup dialog box launcher, and on the Sheet tab, clear both check boxes. If you don’t see colors in the print preview, check that a color printer is selected. You may also want to print gridlines in Excel for easier reading.
A colored header row can also print on every page if you repeat rows at the top of each printed page.
When a Color Won’t Go Away
The color will not go away with No Fill: A conditional formatting rule is drawing it. Select the cells and go to Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. If every other row stays shaded, the range is an Excel table; click a cell in the table, open the Table Styles gallery on the Table Design tab, and choose Clear.
Fill Color is grayed out: The sheet may be protected. Go to Review > Unprotect Sheet, enter the password if one was set, and try again. For how protection and formatting permissions work, read about locking cells in Excel.
You see no colors on screen at all: Windows high contrast mode can hide them. Turn it off in Windows settings.
A fill covers the gridlines: Filled cells hide gridlines. Add borders with Borders > All Borders to bring the lines back.
The color changed after you changed the theme: You used a theme color. Reapply the fill with a standard or custom color.
Excel Cell Color Questions
Can I change the default fill color in Excel?
No. You can’t change the default fill color for a worksheet; all cells start with no fill. As a workaround, color a blank sheet the way you want and save it as an Excel Template with File > Save As. Open it later from File > New, where it is listed under your personal templates.
Why can’t I see the colors I applied?
You may be working in high contrast mode, which can hide colors on screen. If colors show on screen but not in print, check the Black and white and Draft quality settings above.
What is the keyboard shortcut for fill color?
On Windows, press Alt, then H, then H to open the Fill Color palette, and use the arrow keys and Enter to choose a color. There is no single built-in shortcut that applies a color in one keystroke.
Does removing fill color delete my data?
No. Fill color is formatting only. No Fill, Clear Rules, and Format Painter leave the values and formulas in the cells unchanged.
What is the difference between fill color and font color?
Fill color changes the cell’s background. Font color changes the color of the text inside the cell. Both buttons sit side by side in the Font group on the Home tab.
More Excel Guides
- How to print gridlines in Excel
- How to calculate percentage in Excel
- How to clear data but keep formatting in Excel

Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are checked step by step against the device or app maker’s own documentation and tested on his own devices whenever he has the hardware or software, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.