How to Highlight Color in Excel: Cells, Rules, and More

To highlight cells in Excel, select the cells, open Home > Fill Color, and choose a color. For highlighting that changes when values meet a condition, use Home > Conditional Formatting. You can also change font color to make the text stand out. These steps are for Excel for Microsoft 365 on Windows; the same ribbon options are available in Excel for Mac and, with some layout differences, Excel for the web.

What You’ll Need

An Excel workbook with the cells or data you want to emphasize. Save a copy first if you are making a broad change to a valuable workbook.
A color choice that remains readable against the text and fits the purpose of the highlight. For a shared workbook, consider readers who may have difficulty distinguishing certain colors.
For automatic highlighting, a clear rule, such as marking overdue dates, unusually high figures, or repeated entries. You can also apply a fill manually without setting up a rule.

Step-by-Step

Select the cells you want to format. Click one cell, or drag across a range. To select a full column or row, click its letter or number heading. To select separated ranges, hold Ctrl while selecting each range on Windows; on Mac, hold Command. Check the selection before applying a color, especially if the sheet contains adjacent tables.
Apply a background highlight. On the Home tab, find the Font group and click the arrow next to Fill Color, shown as a paint bucket. Choose a color from the Theme Colors, Standard Colors, or Recent Colors area. Excel applies the displayed color to the selected cells. If the bucket itself shows the color you want, clicking the bucket applies it directly without opening the palette.
Choose a custom fill color if needed. Open the Fill Color menu and select More Colors. In the dialog, choose a color or enter RGB values if you have a specific palette to match. Confirm the selection. Use a light fill for most data tables so black or dark text stays easy to read; a strong saturated fill can make small text harder to scan.
Change the text color separately when useful. Select the cells, then use the arrow beside Font Color, the A with a colored underline in the Font group. Choose a contrasting color. Fill Color changes the cell background; Font Color changes the characters. Excel does not have the same freehand text highlighter tool found in Word, so use a cell fill to mark a cell or font color to emphasize its text.
Highlight values automatically with a built-in rule. Select the range to evaluate, then choose Home > Conditional Formatting. Choose a suitable option under Highlight Cells Rules, such as Greater Than, Less Than, Text That Contains, or Duplicate Values. Enter the value or text requested, select a preset format, and click OK. Excel applies the format to cells that satisfy the rule, and can update it when their contents change.
Use a color scale to show relative values. Select a numeric range and choose Home > Conditional Formatting > Color Scales. Pick a two-color or three-color scale. Excel shades cells according to their values relative to the other cells in the selected range. This is useful for spotting low and high values quickly, but it is not the same as assigning a fixed meaning to one particular color.
Review or adjust a conditional-formatting rule. Select a cell in the range, then choose Home > Conditional Formatting > Manage Rules. Use the rules list to inspect the rule, its format, and the range in Applies to. If the rule should cover additional rows, edit Applies to or recreate the rule with the full intended selection. Choose the relevant worksheet in the Show formatting rules for menu if the rule is not visible.
Remove a highlight when it is no longer needed. For a manually applied fill, select the cells, open Home > Fill Color, and choose No Fill. To remove conditional formatting, select the range and choose Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Clear Rules from Entire Sheet removes every conditional-formatting rule on that sheet, so use it only when that is what you intend.

On Excel for Mac, use the Home tab’s Fill Color, Font Color, and Conditional Formatting controls; the names are generally the same, though the ribbon arrangement can vary by window size and update. Excel for the web also has these Home-tab controls, but some advanced rule-management options may be arranged differently or be less complete than in the desktop app. If a button is not visible, widen the window or look in the ribbon’s overflow menus.

Common Mistakes

Clicking the paint bucket instead of its arrow. The bucket applies its current color immediately. If the result is not the color you wanted, use the arrow to open the palette and choose another color.
Confusing fill with font color. A cell can have colored text on a plain background, a colored background with plain text, or both. Check which control you are using before applying a format.
Using manual fill for data that changes. A manually applied color stays in place when a value changes. If the color should reflect the current value, create a conditional-formatting rule instead.
Applying a rule to the wrong range. A rule can be correct but appear ineffective if the selected range or Applies to address omits the cells you meant to format. Review the range in Manage Rules.
Choosing colors that are difficult to read. Dark text on a dark fill or pale text on a pale fill reduces contrast. Check the result at normal zoom and consider whether it will still be clear when printed or viewed by someone with color-vision differences.
Clearing more formatting than intended. Home > Clear > Clear Formats removes formatting beyond the fill, potentially including number formats, borders, and font styles. To remove only a manual background, choose No Fill instead.

Tips

Use a consistent color key. For example, reserve one color for items needing review and another for completed items. If colors have a specific meaning, add a small legend near the table so other people do not have to guess.
Use a theme color for a coordinated workbook. Theme Colors are designed to match the workbook’s theme. A theme color can be more consistent than choosing a random shade, especially across multiple sheets.
Apply a format to a range in one go. Select the full intended range before choosing a fill rather than repeatedly coloring cells one at a time. This is faster and helps keep the formatting consistent.
Use Format Painter for a one-off match. Select a cell with the formatting you want, choose Home > Format Painter, and then select the destination cells. Format Painter copies formatting, not cell values. It can copy more than color, including borders and font settings, so inspect the result.
Keep color scales for comparisons. A color scale is helpful when relative position matters, such as comparing monthly totals. For a clear status such as past due or complete, use a rule that assigns a distinct format to the matching cells instead.
Consider printing and accessibility. Color may look different on paper, in a projector display, or on another monitor. Do not make color the only indicator of an important status; add a label, symbol, or separate status value where appropriate.

Troubleshooting

The selected cells do not change color. Confirm that the cells are still selected and that you clicked the intended control. If you used Conditional Formatting, a rule may only color cells that meet its condition. Try a manual fill on one test cell to check whether the ribbon command works, then inspect the rule and its Applies to range in Manage Rules.

A different color appears than the one you picked. A conditional-formatting rule may be overriding the manual fill, or another rule may have higher priority. Select an affected cell and open Home > Conditional Formatting > Manage Rules. Check which rules apply, their order, and their formats. Edit or remove only the rule responsible; avoid clearing all rules if the sheet relies on other highlights.

The highlight disappears or changes after editing a value. That is expected for conditional formatting: the cell’s appearance depends on whether its current value meets the rule. If you need the color to remain regardless of later edits, remove the relevant rule and apply a manual fill. If the color should respond to the changed value, check that the rule condition and range are appropriate.

Only some cells in the range are highlighted. Check for blank cells, values stored as text, or values that do not actually meet the condition. Also inspect the rule’s Applies to range and whether overlapping rules affect the same cells. For a text rule, check spelling and extra spaces; for a numeric rule, confirm that the entries are numbers rather than text that looks like numbers.

No Fill does not remove the visible color. The color may come from conditional formatting, a table style, or a cell style rather than a manual fill. Check Manage Rules first. If the cells are part of a formatted table, review the Table Design style and banded-row options. Avoid using Clear Formats as a first fix because it may remove useful formatting along with the color.

Frequently Asked Questions

How do I highlight a cell in Excel with a keyboard shortcut?
On Windows, select the cells and press Alt, H, H to open the Fill Color menu, then use the arrow keys to choose a color and press Enter. The sequence may depend on the ribbon configuration. Excel for Mac does not use the same Windows Alt-key sequence; use the Fill Color control on the Home tab or a shortcut you have assigned through Excel’s settings.

Can Excel highlight a cell automatically when I type a certain value?
Yes. Select the range and use Home > Conditional Formatting > Highlight Cells Rules. Choose a rule such as Text That Contains or Equal To, enter the condition, and select a format. The highlight updates when the cell value changes and meets the rule.

Can I highlight an entire row based on one cell?
Yes, but a custom conditional-formatting formula is usually needed so the rule checks one column while applying formatting across each row. Select the rows you want formatted and set up a formula-based rule that refers to the status column. Make sure the rule’s Applies to range covers the full rows or table columns you want highlighted.

How do I highlight duplicate values?
Select the cells to check, then choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Choose the format and confirm. Excel highlights duplicates within the selected range; selecting a larger range can change which entries count as duplicates.

Can I highlight only part of the text inside a cell?
Yes, for text entered directly in a cell, edit the cell, select the characters in the formula bar or in-cell editing, and use the Font Color control to change their text color. Excel does not provide a Word-style background highlighter for just selected characters; a cell fill colors the whole cell.

Will my highlighting appear when I print or share the workbook?
Cell fills and font colors are usually included when you print or share the workbook, but print settings, display themes, and recipients’ software can affect how they look. Use Print Preview to check the page and avoid relying on color alone to communicate essential information.

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.