To highlight cells in Microsoft Excel, select the cell or range, then choose Home > Fill Color and pick a color. This applies a background fill; for highlights that update automatically when values change, use Home > Conditional Formatting instead. The steps below are for Excel for Microsoft 365 on Windows, with notes for Mac and Excel for the web.
What You’ll Need
- An Excel workbook with the cells you want to emphasize. If the workbook is stored in OneDrive or SharePoint, make sure you have permission to edit it.
- A color choice that remains readable with the cell text. Consider accessibility and avoid relying on color alone to convey important information.
- For conditional highlighting, a clear rule, such as marking values above a limit or cells containing a particular word.
Step-by-Step
- Open the workbook and identify what you want to highlight. Decide whether you need a one-time color that you apply yourself or a rule-driven highlight that changes when the data changes. Manual fill is suitable for emphasis, headings, or a small number of selected cells. Conditional formatting is better for recurring criteria, such as overdue dates or duplicates.
- Select the cell or range. Click a single cell to color it. For a group of adjacent cells, click the first cell and drag across the range, or select the first cell, hold Shift, and click the last. To select a whole column or row, click its letter or number heading. To highlight separate, non-adjacent cells, hold Ctrl while clicking each cell on Windows; on Mac, hold Command while selecting additional cells. Check the selection before applying a color, because every selected cell will receive the fill.
- Open the Fill Color menu. On the Home tab, find the Font group and click the arrow beside the paint-bucket-shaped Fill Color button. The button itself usually shows the most recently used fill color. Clicking the button directly applies that color; using its arrow opens the palette so you can choose a different one. On Windows, Alt, H, H is the ribbon key sequence for opening the Fill Color menu. Press the keys in order rather than all at once. Excel for Mac does not have the same reliable ribbon sequence across keyboard layouts, so use Home > Fill Color.
- Choose a suitable color. Pick a color from Theme Colors or Standard Colors. For a custom shade, choose More Colors if it appears in the palette, then choose a color in the dialog and confirm. A pale fill is often easier to read behind black text than a dark, saturated color. If you choose a dark fill, check whether the existing font color still has enough contrast; the fill command changes the background, not the text color.
- Check the result and adjust it if needed. Click outside the selected range and confirm that only the intended cells changed. If the color is too strong or makes text difficult to read, select the cells again and choose a lighter fill. You can use Home > Font Color to change the text color separately. To undo the last fill immediately, use Ctrl+Z on Windows or Command+Z on Mac.
- Use conditional formatting when the highlight should follow a condition. Select the data range, then choose Home > Conditional Formatting. Point to Highlight Cells Rules and choose a rule such as Greater Than, Less Than, Between, Equal To, Text that Contains, A Date Occurring, or Duplicate Values. Enter the value or text the rule should look for. Choose a preset format, or select Custom Format if available to set a fill and other formatting, then confirm. The selected range will be formatted when its values meet the rule.
- Review the conditional-formatting range and rule. Select a cell in the formatted area and open Home > Conditional Formatting > Manage Rules. In the rules manager, inspect the rule and its Applies to range. If the range is too short, edit it so new or existing data cells are included. In the Show formatting rules for list, select the current selection or the relevant worksheet to find the rules you need. The rule can remain in place while you edit cell values, so matching cells update without applying fill again.
- Remove highlighting without disturbing the data. For a manual fill, select the cells, open Home > Fill Color, and choose No Fill. For conditional formatting, select the affected range and choose Home > Conditional Formatting > Clear Rules, then choose Clear Rules from Selected Cells. Use Clear Rules from Entire Sheet only when you mean to remove all conditional-formatting rules from that worksheet. Clearing conditional formatting does not delete values, but clearing a manual fill may not remove other formatting such as bold text or borders.
Excel for Mac has the same basic Fill Color and Conditional Formatting controls on the Home tab, though the ribbon layout and some dialog labels can differ slightly by version. In Excel for the web, select the cells and use the Home tab’s Fill Color control; conditional-formatting options are also available from Home > Conditional Formatting, but some advanced rule editing may be easier in the desktop app. If a menu looks different, look for the same named command on the Home tab.
Common Mistakes
- Clicking the color button instead of its arrow. The main Fill Color button repeats the last-used color. If you expected a palette but cells changed immediately, use Ctrl+Z or Command+Z, then open the arrow beside the button and select the intended color.
- Selecting the wrong range. A highlight may spread across a whole column or stop before the last data row if the selection was inaccurate. Before choosing a color or rule, verify the selection border or check the range shown in Excel’s Name Box.
- Expecting a manual highlight to update. A fill color does not respond to changes in cell contents. If the goal is to keep marking values that meet a changing condition, create a conditional-formatting rule instead.
- Making text hard to read. Dark fills behind dark font, or bright fills behind small text, can reduce legibility. Check the result at normal zoom and use Font Color separately if the text needs to change.
- Using Clear Formats to remove only a highlight. Clear Formats can remove other formatting as well, including number formats, fonts, and borders. Choose No Fill to remove manual background color, or Clear Rules from Selected Cells to remove conditional formatting.
Tips
- Use a consistent color key. For example, reserve one pale color for inputs and another for items needing review. Keep a small legend near the data if other people need to interpret the colors. Avoid assigning the same color to unrelated meanings.
- Use conditional formatting for changing lists. If you regularly add rows, make sure the Applies to range includes them. You can select a larger range in advance, or convert a simple data range into an Excel table with Insert > Table; table formatting and conditional-formatting behavior can help accommodate added rows, but always verify the rule’s range.
- Choose rules that match the task. Use Text that Contains for a word or phrase, Duplicate Values to find repeated entries, and Greater Than or Between for numeric thresholds. A rule should reflect the actual data you want to flag; for example, a date stored as text may not behave like a real Excel date.
- Keep color accessible. Use sufficient contrast and do not communicate status only through color. Add a status label, symbol, or text value as well, especially when the workbook will be shared or printed in grayscale.
- Copy formatting deliberately. If you want to reuse a manual fill, copy the cell and use Paste Special > Formats, or use Format Painter on the Home tab. Check the destination afterward because copied formats may include fonts, borders, and number formats in addition to the fill.
- Understand the difference between cell fill and text emphasis. Excel’s Fill Color colors the entire cell background; it is not a marker-style tool for coloring only selected words inside a cell. To emphasize text within a cell, edit the cell and select the text in the formula bar or in-cell editing mode, then use Font Color or bold formatting where supported.
Troubleshooting
The color does not change. Confirm that the intended cells are selected and that the worksheet is not protected against formatting changes. If the workbook is shared or opened read-only, you may not have permission to save edits. Try applying a different fill to one test cell; if that works, reselect the original range carefully.
The fill appears to be missing or the text is difficult to see. Check that you did not choose No Fill, and inspect the selected cells with a contrasting color. Conditional formatting may be overriding the manual fill: select a cell and open Home > Conditional Formatting > Manage Rules to review rules that apply to it. Adjust or remove the relevant rule if appropriate. Also check whether the workbook uses a table style that makes the fill look different from the palette preview.
A conditional-formatting rule highlights the wrong cells. Reopen Manage Rules and check both the condition and Applies to range. Make sure the rule starts at the same row as the range you intended. For a text rule, check for extra spaces or inconsistent spelling in the source cells. For number and date rules, confirm that the entries are stored as numbers or dates rather than text; changing a cell’s display format alone does not always convert text into a real date or number.
New rows are not highlighted. The rule may not include those rows. In Manage Rules, expand Applies to to cover the added cells, or adjust the data structure so the rule includes future entries. When working with a table, check the rule after adding rows because copied table formatting and conditional formatting are separate things.
The color changes after copying or opening the file elsewhere. A copied cell may bring along other formatting, and theme colors can look different when a workbook’s theme changes. Use No Fill before applying a fresh fill if you want to remove a manual background first. For a shared workbook, choose a theme color and verify its appearance in the app and display where the file will be used.
Frequently Asked Questions
How do I highlight a whole row in Excel?
Select the row number at the left edge of the worksheet, then choose Home > Fill Color and pick a color. For a row that should highlight only when a cell meets a condition, select the relevant table range and create a conditional-formatting rule; a rule based on one column may require a formula to apply the formatting across the row.
Can I highlight cells that contain specific text?
Yes. Select the range, choose Home > Conditional Formatting > Highlight Cells Rules > Text that Contains, enter the text, choose a format, and confirm. The rule can flag cells containing that text as their contents change.
How do I highlight duplicate values?
Select the cells to check, then choose Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values. Choose a format and confirm. Limit the selection to the relevant column or range so Excel checks duplicates in the intended part of the worksheet.
Can Excel highlight only part of the text inside a cell?
Not with the Fill Color command, which colors the cell background. You can format selected characters manually with Font Color or bold, but conditional formatting applies to cells rather than individual matching words within a cell.
How do I remove a highlight but keep the cell contents?
For a manually applied background, select the cells and choose Home > Fill Color > No Fill. For a rule-based highlight, use Home > Conditional Formatting > Clear Rules > Clear Rules from Selected Cells. Neither option deletes the cell’s contents.
Can I highlight a cell automatically based on its value?
Yes. Select the cells and choose an appropriate rule from Home > Conditional Formatting, such as Greater Than, Less Than, or Between. Set the condition and format. Excel then applies or removes the highlight as the cell values change, provided the values are recognized in the expected type.
Related
- Find Duplicate Names in Excel: A Step-by-Step Guide
- How to Find Duplicate Names in an Excel Column
- Find Duplicate Entries in an Excel Column
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Template for Quotation Comparison: Build OneIn Excel for Microsoft 365 on Windows, create supplier columns in B:D, enter each quote’s comparable costs in…
- How to Merge Cells in Google Sheets and Keep Data SafeTo merge cells in Google Sheets in a web browser, select the adjacent cells, then choose Format >…
- Excel Sum Duplicates: How to Total Repeated ValuesTo sum values associated with repeated names or codes in Excel, use SUMIF: it adds the numbers in…
- Clear Cache in Microsoft Outlook: Windows, Mac & WebTo clear the cache in Microsoft Outlook, use the method for your version: empty the Auto-Complete list or…
- Excel Solver Answer Report: Create and Read ItTo create a Solver Answer Report in Excel, set up and solve your model, then select Answer in…
- Excel Solver Two-Variable Example and SetupFor a two-variable Excel Solver example, maximize profit from chairs and tables by changing the number of each…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.