How to Color an Excel Spreadsheet: Cells, Rows, and More

How-to basics · Updated November 20, 2026

To color cells in Excel for Microsoft 365 on Windows, select the cells, open the Home tab, and choose a color from the Fill Color menu (the paint-bucket icon). Use the Font Color menu to change text color. These tools can highlight important values, distinguish sections, and make a sheet easier to scan. You can also color whole rows, columns, worksheet tabs, or cells automatically when they meet a condition.

What You’ll Need

  • Microsoft Excel for Microsoft 365 on Windows, or access to the workbook in Excel for Mac or Excel for the web. Menu names are generally similar, though ribbon layouts and some shortcuts differ.
  • A workbook and a clear idea of what the colors should communicate. For example, choose one color for inputs and another for totals, rather than coloring cells at random.
  • Editing access to the sheet. If a workbook is protected, you may need the owner to allow formatting before you can change colors.

Step-by-Step

  1. Select the cells you want to color. Click one cell, then drag across a range. To select a range using the keyboard, click its first cell, hold Shift, and click the last cell. You can also click a column letter or row number to select that whole column or row. To select several separate ranges, hold Ctrl on Windows while selecting each range; on Mac, hold Command. Check the highlighted selection before applying a color: a selection that is one row too tall or one column too wide can change more of the sheet than intended.
  2. Apply a background fill. On the Home tab, find the paint-bucket icon in the Font group. Click the main part of Fill Color to apply the color currently displayed on the icon. To choose a different color, click the small arrow beside it, then choose a color from Theme Colors, Standard Colors, or More Colors. The color is applied to the selected cells immediately. If you use the same color repeatedly, the main button applies the most recently chosen fill, while its arrow lets you select another one.
  3. Choose a custom color if needed. From the Fill Color arrow, choose More Colors to open the custom color picker. Select a color or enter its RGB values if you have an exact brand color to match, then confirm. Theme colors are often preferable for ordinary spreadsheet design because they fit Excel’s theme palette. A custom color can be useful for a precise match, but it may not adapt if the workbook’s theme changes. If the chosen shade looks different from what you expected, check the selected cells and the preview before confirming.
  4. Change the text color for contrast. Select the cells, open Home > Font Color using the arrow beside the A-with-color-bar icon, and choose a readable text color. A pale fill usually works well with dark text; a dark fill generally needs light text. Do not assume that changing Fill Color also changes the font color: they are separate settings. Check small text and numbers at normal zoom, not only when enlarged, and avoid color combinations that make labels difficult to read.
  5. Color a whole row or column. Click the row number on the left or the column letter at the top to select it, then use Fill Color. To color only part of a row, select the cells within that row instead. For alternating bands, avoid manually coloring every other row if the data will grow or be sorted. Instead, select the data and choose Home > Format as Table, select a style, and confirm whether the table has headers. Excel applies a coordinated style with banded rows; new table rows generally inherit the style. Table formatting may add filter buttons and table behavior, so it is best for actual data lists rather than every kind of layout.
  6. Color a worksheet tab when you want to identify a sheet. Right-click the sheet tab at the bottom of the window, choose Tab Color, and select a color. The tab color helps distinguish worksheets such as Inputs, Summary, and Archive, but it does not color cells inside the sheet. To change it on a Mac, Control-click or right-click the tab and use the tab-color option in the context menu. In Excel for the web, use the tab’s context menu if the option is available in your current interface.
  7. Use conditional formatting for values that change. Select the cells to monitor, then choose Home > Conditional Formatting. For a quick visual scale, open Color Scales and select a preset; Excel shades values relative to the other values in the selected range. For a rule such as highlighting values below a target, choose Highlight Cells Rules, select the relevant rule, enter the threshold, and select a format. You can use New Rule for more control. Conditional formatting updates when values change, unlike a fill you apply manually. Review the selected range and rule before closing the dialog, especially if the sheet contains blanks or values that should not be compared.

On Windows, pressing Alt+H, H opens the Fill Color menu through Excel’s ribbon key tips. Key tips can vary with the interface, so using the ribbon button is the clearest method if that shortcut does not work. Excel for Mac has different keyboard shortcuts; use the Home tab’s color controls rather than relying on the Windows sequence. Excel for the web also provides fill and font color controls on its Home ribbon, though the arrangement can differ from the desktop app.

Common Mistakes

Coloring the wrong range: A whole-column selection affects existing cells and cells you may use later. For a small data block, select just the cells you need. If you notice the error right away, use Undo; otherwise select the affected cells and choose the appropriate fill again.

Mixing up fill and font color: The paint bucket changes the cell background, while the A icon changes text. If numbers disappear against a new background, select the cells and adjust Font Color as well as Fill Color.

Using color as the only signal: A red fill alone may not tell every reader whether a value is late, incorrect, or simply important. Add a clear heading, label, symbol, or note. This also helps when someone prints the sheet in grayscale or has difficulty distinguishing colors.

Applying too many unrelated shades: A different color for every category can make a sheet noisy and harder to interpret. Decide on a small, consistent palette and use the same meaning for each color throughout the workbook. Also check contrast: pale text on a pale fill and dark text on a dark fill are both difficult to read.

Expecting a manual fill to update with data: A manually chosen color stays in place when a cell’s value changes. Use conditional formatting when color should respond to values, dates, or thresholds, and verify that the rule covers the range where future data will appear.

Tips

  • Use a light fill for large blocks of data and reserve stronger colors for a small number of important items. This keeps the content, rather than the decoration, easy to see.
  • Apply a color to a heading row, then use bold text and a clear label as well. A heading should remain understandable even if the workbook is printed without color.
  • Keep a simple color key near the data when colors carry specific meanings. For example, label what green, amber, and red indicate instead of assuming every reader knows.
  • Use Home > Format Painter to copy formatting from a correctly colored cell to another area. Click Format Painter, then select or drag over the destination. Double-click Format Painter if you need to apply the same formatting to several separate areas, and press Esc when finished. It copies other formatting too, such as borders and font styles, so inspect the result.
  • To remove a fill without removing the cell’s contents, select the cells, open the Fill Color arrow, and choose No Fill. To remove all formatting, use Home > Clear > Clear Formats, but note that this also removes number formats, borders, and font styling.
  • For a consistent workbook palette, use colors from the same theme rather than choosing unrelated custom shades for each sheet. The Page Layout > Colors menu changes the workbook theme palette; it does not necessarily replace every custom color already applied.
  • Before sharing, inspect the sheet at normal zoom and, if relevant, use print preview to check that labels remain legible on paper. Avoid relying on subtle shades to separate adjacent values.

Troubleshooting

The color button changes a different shade than expected: The main Fill Color button applies its current color directly. Click the small arrow beside it to open the palette and choose another shade. If you are unsure which cells are selected, click a blank cell and select the intended range again.

The fill color does not appear to change: First check whether the sheet or workbook is protected. If Excel prevents formatting, look for Review > Unprotect Sheet; a password may be required, and you should ask the workbook owner rather than trying to bypass protection. Also check whether conditional formatting is applying a different color over your manual fill. Open Home > Conditional Formatting > Manage Rules, inspect the rules for the selected cells, and edit or remove a rule only if it is no longer needed.

Only some cells changed: Confirm the selection and check for merged cells, which can make a range behave differently than expected. Select the affected area again and apply the color. If the cells are part of a formatted table, the table style may control their appearance; use the table style options or adjust the table style instead of repeatedly painting individual cells.

A color looks different after changing the theme: Theme-based colors can change appearance when the workbook theme changes, while custom colors are less tied to the theme. Reopen the color palette and select the intended shade, or set a custom color through More Colors. If the workbook is shared, coordinate theme changes because they can affect other theme-based elements too.

The sheet is hard to read after formatting: Select the affected cells and restore a neutral fill, then add only the colors that communicate useful information. Check font color, font size, and contrast together. If a conditional-formatting scale creates confusing results, use Home > Conditional Formatting > Clear Rules for the selected cells, or edit the rule so it applies only to the intended range.

Frequently Asked Questions

How do I color an entire Excel spreadsheet?
Select the Select All button at the corner above the row numbers and left of the column letters, then choose a Fill Color. This colors the worksheet’s cells, not its sheet tab. It can make a workbook harder to read and can affect the appearance of cells used later, so use it only when a full-sheet background is really needed.

Can I color a cell based on its value?
Yes. Select the range and choose Home > Conditional Formatting, then select a rule such as a highlight rule or color scale. Set the comparison or range as needed. Conditional formatting is useful when the color should change as the underlying value changes.

How do I color alternate rows?
For a data list, select it and choose Home > Format as Table, then choose a style with banded rows and confirm the header setting. If you only need a one-time appearance for a fixed range, you can manually color alternate rows, but newly added rows will not automatically follow that pattern.

Can I apply the same color to multiple separate cells?
Yes. Hold Ctrl on Windows (Command on Mac) while selecting separate cells or ranges, then choose a fill color. If it is easier, apply the color to one range and use Format Painter for the others. Check that all the selected areas are highlighted before applying formatting.

How do I remove color but keep the data?
Select the cells, open the Fill Color menu, and choose No Fill. The cell contents remain. If the color comes from a conditional-formatting rule, remove or edit the rule instead; choosing No Fill alone may not override the rule’s displayed color.

Related

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.