How to Insert Color in Excel: Cells, Text, and Rules

To add color in Excel, select the cells, open Home > Font > Fill Color, and choose a swatch; to color the letters instead, use Font Color in the same group. For colors that change when values change, use Home > Conditional Formatting. These tools work in Microsoft Excel for Microsoft 365 on Windows, and the same basic options are available in Mac and web versions.

Color can make headings stand out, distinguish input cells from calculated results, or help readers spot values that meet a condition. The key is to choose the right kind of formatting: a fill colors the cell background, font color changes the text, and conditional formatting applies a color automatically according to a rule.

What You’ll Need

An Excel workbook with the cells, table, or data you want to format.
A color scheme or a simple plan for what each color means. For example, you might use light blue for editable inputs and green for completed items.
For a custom brand color, its RGB values if you have them. You can also choose from Excel’s built-in palettes without preparing a color code.

Step-by-Step

Select the cells to color. Click one cell, or drag across a range. To select a whole column or row, click its letter or number heading. To select separate, nonadjacent cells on Windows, hold Ctrl while clicking each one; on Mac, hold Command. Selecting the range first helps ensure the color is applied only where intended. If you are working in a formatted Excel table, select the relevant table cells rather than the entire worksheet.
Apply a background fill. Go to Home and find the Font group. Click the arrow beside the paint-bucket-shaped Fill Color button, then choose a color from the palette. The main button applies its displayed color immediately, while the arrow opens the choices. Excel updates the selected cells, so check that the selection outline covers the right range before choosing.
Choose a suitable palette color. The palette includes theme colors, variations of theme colors, and standard colors. Theme colors are designed to work together and can change if the workbook theme changes; standard colors are more independent of the theme. Hover over a swatch to preview it on the selected cells, when previews are available, and read the displayed color name or value if shown. Prefer a light fill behind dark text for tables and long labels, because strong dark fills can make ordinary text difficult to read.
Set a custom fill if needed. Open the Fill Color arrow and choose More Colors. In the color dialog, use the custom controls to enter RGB values or choose a color, then confirm. The exact dialog can vary slightly by Excel version. On Excel for the web, the palette and custom-color controls may be more limited than in the Windows desktop app; use desktop Excel if you need precise RGB entry. After applying a custom color, it may appear among recent colors for convenient reuse.
Color the text separately when useful. Select the cells, open the arrow beside Font Color in Home > Font, and choose a swatch. This changes the characters, not the cell background. Use font color for emphasis on a few labels or values, and check that there is enough contrast with the fill. Avoid relying on color alone to communicate meaning; include a label, symbol, or status word as well.
Use Conditional Formatting for values that can change. Select the range to monitor, then choose Home > Conditional Formatting. For a simple rule, open Highlight Cells Rules, choose an option such as Greater Than or Text That Contains, enter the value or text, and choose a formatting option. To define the appearance yourself, choose Custom Format if offered in the rule dialog, or choose New Rule and set a fill or font color in its formatting controls. Click OK to apply the rule. This formatting updates as the cell values change.
Use color scales to show a range of values. Select numeric cells and choose Home > Conditional Formatting > Color Scales, then select a two-color or three-color scale. Excel shades cells according to their relative values, which can make high and low numbers easier to compare. Color scales are most useful when values are comparable; they can be misleading if the range includes text, totals, or numbers with different meanings.
Check and adjust the result. Click outside the selection to see the colors without the active-cell border. If the fill is too strong, select a lighter shade or use a different theme color. To remove a direct cell fill, select the cells, open Home > Fill Color, and choose No Fill. To remove font coloring, use the Font Color menu and choose Automatic or the default text color. If a conditional rule is responsible, clear or edit that rule rather than repeatedly applying a direct fill.

On Mac, use the same Home ribbon controls; some dialog layouts and keyboard navigation differ. Excel for the web also has Home ribbon color controls, although advanced custom color and rule-editing options can vary. If you do not see a particular choice, open the relevant dropdown or use the desktop app.

Common Mistakes

Clicking the color button instead of its arrow. The main Fill Color or Font Color button applies the currently displayed color. If you meant to choose another shade, open the small dropdown arrow next to it.
Coloring the wrong range. A whole-column selection can color blank cells far below your data. Select only the used cells when possible, and confirm the highlighted range before applying the fill.
Confusing fill color with font color. Fill changes the cell background; Font Color changes the text. If the cell looks unchanged, check which control you used and whether the text or background is what you intended to modify.
Using too many colors or low contrast. A rainbow of unrelated fills makes a worksheet harder to scan. Use a small, consistent palette and make sure text remains readable. Consider how the sheet will look when printed in grayscale.
Expecting a manual fill to behave like a rule. A direct fill stays in place even if a value changes. If the color should respond to a number, date, or text value, use Conditional Formatting and make sure its rule covers the right range.
Overwriting a table’s appearance. Excel table styles can add banded rows and header colors. Direct fills may compete with those styles or make the design inconsistent. If the table’s overall look should change, consider the table style options rather than coloring many cells individually.

Tips

Give each color a clear meaning. For example, use one restrained color for user-entered cells and another for warnings. Add a short legend near the table so someone opening the workbook can understand the scheme without guessing.
Reuse colors consistently. Use theme colors when you want a coordinated workbook palette. For exact shades, use the custom color controls where available and reuse recent colors. Applying the same meaning to the same color across sheets makes a workbook easier to follow.
Consider accessibility. Do not communicate a required distinction only by red versus green, since some readers may not distinguish those colors easily. Add text such as Needs review or Complete, or use an icon or another visual cue. Check that text and cell fills have strong contrast.
Keep important data easy to print. Heavy fills can consume ink and obscure gridlines. Try a pale shade, bold text, or a border for emphasis, and use Print Preview to check whether the colors remain readable on the page.
Copy formatting carefully. If you want the same look in another area, copy the source cells and use Paste Special > Formats where available, or use Format Painter on the Home tab. These options copy appearance rather than values, but may also transfer number formats or other formatting, so inspect the destination afterward.
Use conditional rules for recurring reviews. A rule that highlights overdue dates or values below a target can save repeated manual recoloring. Give the rule a concise description, choose a readable format, and verify its Applies to range so it does not include unrelated cells.

Troubleshooting

The color menu does not appear: Make sure you clicked the small arrow beside the Fill Color or Font Color button, not just the button itself. If the ribbon is collapsed, expand it or select the Home tab. In a narrow window, some controls may be grouped or displayed in a compact layout.

The cells do not change color: Confirm that the intended cells are selected and that the worksheet is not protected from formatting changes. If the sheet is protected, ask the workbook owner to allow formatting or unprotect the sheet if you have permission. Also check whether a conditional formatting rule or table style is affecting how the cells appear.

A different color appears than the one you chose: Conditional Formatting can take precedence visually over a manual fill. Select the affected cell and open Home > Conditional Formatting > Manage Rules to inspect rules for the current selection or worksheet. Edit the rule, adjust its range, or remove it if it is no longer needed. On some versions, the rule manager offers a dropdown for which rules to show; choose the current selection or this worksheet as appropriate.

The fill disappears or does not show in print: Check the selected color again and use Print Preview to review the output. A very pale shade can be hard to see on a monitor or printer. Worksheet gridlines are separate from cell fills, so adding a fill can make gridlines less visible; add borders if you need clear cell boundaries. Check printer settings and avoid assuming that screen colors will reproduce exactly on paper.

You cannot enter an exact custom color: Use the Windows desktop version and open More Colors from the color dropdown. If the dialog or custom controls are missing in Excel for the web, open the workbook in the desktop app. In a shared workbook, permissions or organizational settings may also limit editing, so check whether other formatting changes are allowed.

Frequently Asked Questions

How do I color an entire row in Excel?
Select the row by clicking its number heading, then choose a fill from Home > Fill Color. To color only part of the row, drag across those cells instead. For a row that should change color based on a value, use Conditional Formatting on the relevant range.

Can I apply color automatically when I type a value?
Yes. Select the cells first, create a rule through Home > Conditional Formatting, and choose the condition and format. For example, a rule can highlight values greater than a threshold or cells containing a particular word. The rule applies when the cell meets the condition, so check its Applies to range.

How do I remove color without deleting the cell contents?
Select the cells, open the Fill Color menu, and choose No Fill. This removes a direct background fill without clearing values. If the color comes from Conditional Formatting, edit or delete the rule instead; choosing No Fill alone may not remove the rule’s displayed color.

Can I color only part of the text inside a cell?
Yes, in desktop Excel you can edit the cell, select particular characters in the formula bar or cell, and apply Font Color to the selected text. The exact selection method can be awkward in Excel for the web, so use the desktop app if you need detailed character-level formatting. This is different from applying a font color to the entire cell.

Why can I see the color on screen but not the worksheet gridlines?
Gridlines and fills are different. A filled cell can make its gridline less visible, even though the fill is working normally. Apply borders from Home > Font > Borders if you need cell divisions that remain visible alongside the fill.

Will the colors stay when I share the workbook?
Cell fills, font colors, and conditional formatting are saved in the workbook and generally appear in current Excel versions. Other spreadsheet programs may display some formatting differently, and printed colors can vary by printer. If the colors are important, include labels or a legend so the meaning is clear even if the appearance changes.

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.