How to Highlight Cells Yellow in Excel

To highlight cells yellow in Excel for Microsoft 365 on Windows, select the cell or range, open Home > Fill Color (the paint-bucket icon), and choose a yellow swatch. The cells will display a yellow background while keeping their contents unchanged. You can also use conditional formatting when you want Excel to apply yellow automatically based on a value or rule.

In Excel, “highlight” usually means changing a cell’s fill color. Excel does not have the same text-marker highlighter tool found in Word, so the steps below focus on coloring the cell background. If you only want the letters to appear yellow, use Font Color instead, but check that the text remains easy to read.

What You’ll Need

A workbook open in Excel for Microsoft 365 on Windows. The ribbon steps are similar in Excel 2021 and newer desktop versions.
Permission to edit the workbook. If it is read-only or protected, you may need to save an editable copy or ask the workbook owner to unlock the relevant cells.
The cell, range, row, or column you want to emphasize. You can select it before applying a color.

Step-by-Step

Open the worksheet and locate the cells. Click the worksheet tab at the bottom of the Excel window, then find the data you want to mark. Decide whether yellow should cover just one cell, several adjacent cells, or an entire row. For example, to draw attention to a delivery date, color the date cell rather than the whole table unless you want the entire record to stand out.
Select the target cells. Click a single cell to select it. For a continuous range, click the first cell and drag across to the last, or click the first cell, hold Shift, and click the last cell. To select separate cells or ranges, hold Ctrl while clicking or dragging each one. On a Mac, use Command instead of Ctrl for non-adjacent selections. Check the highlighted selection border before changing the fill so you do not color neighboring data by accident.
Find the Fill Color control. Select the Home tab on the ribbon. In the Font group, locate the paint-bucket icon labeled Fill Color. The small color bar beneath the icon shows the color that will be applied if you click the main button. If that bar is already yellow, you can click the main part of the button to apply it immediately. If it shows another color, open the menu using the arrow beside the icon.
Choose a yellow shade. In the Fill Color palette, choose a yellow swatch from Theme Colors or Standard Colors. A theme yellow may change slightly if the workbook theme changes; a standard yellow is a straightforward choice for a bright highlight. Pause over a swatch to see its name or preview where available, then click the shade you want. The selected cells should now have a yellow background.
Check the result and adjust the shade if needed. Click an unfilled cell to see the color without the selection border. If the yellow is too strong, select the cells again, open the Fill Color menu, and choose a paler yellow or a custom shade. To create a custom color, open the palette’s More Colors option if available, select a color in the dialog, and confirm. Keep contrast in mind: black text on a light yellow fill is usually easier to read than pale text on bright yellow.
Apply the same yellow to another selection. Select the next cell or range and click the main Fill Color button if the yellow you chose is still the current color. If the button’s color bar has changed, open the arrow menu and select the intended yellow again. This is useful for marking several important cells without recoloring the entire sheet.
Use a keyboard-friendly selection method when helpful. To select a contiguous block from the active cell, hold Shift and use the arrow keys, then choose the fill from the ribbon. On Windows, you can access ribbon commands with keyboard navigation by pressing Alt and following the key tips shown on screen; the exact letters can vary by Excel build and ribbon configuration. Excel for Mac uses different shortcut and ribbon-key behavior, so use the visible Home tab controls if the Windows key tips do not apply.

To color a whole row or column: click the row number at the left edge or the column letter at the top, then choose yellow from Home > Fill Color. For only part of a row, select the relevant cells rather than the row heading. This avoids highlighting blank cells or unrelated fields across the worksheet.

To remove the fill later: select the colored cells, open the arrow beside Fill Color, and choose No Fill. Do not choose a white swatch if you want to remove formatting: white is a fill color and may cover a sheet background or interfere with existing formatting.

To highlight cells automatically: select the range, then choose Home > Conditional Formatting and select an appropriate rule, such as Highlight Cells Rules for a value condition. Choose a rule and set its format to a yellow fill when the dialog offers that choice. Conditional formatting is useful for changing values, but it is different from manually applying a fixed fill; the color appears when the rule’s condition is met.

Common Mistakes

Using Font Color instead of Fill Color. The Font Color button changes the letters, while Fill Color changes the cell background. Both controls are in the Home tab’s Font group and often use similar color palettes. If the text turned yellow but the cell did not, undo the change with Ctrl+Z on Windows or Command+Z on Mac, then use the paint-bucket Fill Color control.
Clicking the main button when it is set to the wrong color. The main Fill Color button applies its currently displayed color without opening the palette. Check the small bar under the icon first. Use the arrow to pick yellow when the current color is not the one you want.
Selecting too much or too little. A row heading selects every cell in that row, while dragging over a range selects only the cells under the pointer. If the colored area is incorrect, undo immediately and make a more precise selection. When selecting separate areas with Ctrl or Command, make sure each intended range remains selected before applying the fill.
Expecting a manual fill to update with changing data. A yellow fill applied from the palette stays there until someone changes or clears it. It will not automatically follow a value that moves or changes. Use Conditional Formatting for highlights that should respond to a rule.
Choosing a shade that makes text hard to read. Bright yellow may be distracting, especially across a large table. A lighter shade and dark text are generally more legible. Consider whether color is the only signal; labels such as “Needs review” help readers who print in grayscale or have difficulty distinguishing colors.

Tips

Use one consistent yellow for the same meaning. For example, reserve pale yellow for cells that need review and use another formatting style for completed items. Consistency helps people understand a workbook without guessing what each color means.
Apply fill to a sensible range. Highlighting only the key value can keep a worksheet readable. If a complete record needs attention, apply yellow across that row’s data cells, not necessarily the whole worksheet row. This keeps the emphasis connected to the relevant information.
Use Format Painter for a matching style. Select a cell that already has the desired fill, choose Home > Format Painter, and then click or drag over the destination cells. This can copy other formatting too, such as borders and number formats, so inspect the destination afterward. If you need only the color, using Fill Color directly is safer.
Keep a short color key in shared workbooks. A note near the table can explain what yellow means, such as “Yellow = confirm this value.” This is especially useful when the workbook is handed to colleagues or used after a long gap.
Consider accessibility and printing. Color alone may not be visible to everyone, and some printers reproduce yellow very faintly. Pair the fill with clear text, a symbol, or a status label when the distinction matters for decisions.

Troubleshooting

The cells did not turn yellow. Confirm that the intended cells are selected, then use the arrow beside Fill Color and choose a visible yellow swatch. If the worksheet is protected, Excel may prevent formatting. Check Review > Unprotect Sheet if you are authorized and have the password; otherwise ask the owner for access.
The fill button is unavailable or disabled. The workbook may be in a mode that limits editing, the sheet may be protected, or you may not have edit permission. Check whether Excel shows a read-only or protected-view notice, and use the available editing option only if the file is trusted. If the workbook is shared with restricted permissions, request permission rather than trying to bypass it.
A cell stays yellow after you choose No Fill. A conditional formatting rule may be applying the color. Select the affected cell and open Home > Conditional Formatting > Manage Rules. Inspect the rules that apply to the selection, then edit or delete the relevant rule if appropriate. A manual fill and a conditional format can coexist, and the conditional format may control the displayed appearance.
The color changes when a value changes. This is likely conditional formatting. Review the rule under Home > Conditional Formatting > Manage Rules and check its range and condition. If you want a permanent yellow background instead, remove or adjust the rule, then apply the fill manually. Save a copy first if changing rules in a shared or important workbook.
The yellow looks different on another computer. A theme color can vary with workbook theme settings, and screen or printer settings also affect appearance. Choose a standard or custom yellow if consistency matters, then check the workbook on the intended display or print preview. Avoid relying on tiny differences in shade to communicate essential information.
You are using Excel for the web or Mac. In Excel for the web, select the cells, open the Home tab, and use Fill Color; the palette may be arranged differently from the Windows desktop version. On Mac, the Home tab and paint-bucket control are also available, but keyboard shortcuts differ: use Command where Windows instructions use Ctrl for selection and undo. If a menu item is missing, check that you are editing rather than viewing the workbook.

Frequently Asked Questions

Can I highlight only part of the text inside an Excel cell?
Yes. Double-click the cell or select the text in the formula bar, highlight the characters, then use the Font Color control to change their text color. Excel does not provide Word’s marker-style text highlighting for a selected phrase. To make the cell stand out, apply a fill color to the cell instead.

How do I make the yellow highlight lighter?
Select the cells, open the arrow beside Home > Fill Color, and choose a paler yellow from the palette. If none of the swatches works, use More Colors if available to choose a custom shade. A light fill usually preserves readable dark text better.

Can I highlight several non-adjacent cells at once?
Yes. On Windows, hold Ctrl while selecting each cell or range; on Mac, hold Command. Once all the areas are selected, choose yellow from the Fill Color menu. If the selection is lost, start again and verify all target areas are selected before applying the color.

How do I highlight cells yellow when they contain a certain value?
Select the cells to check and use Home > Conditional Formatting. Choose a suitable rule, such as a rule for cells equal to a value, enter the condition, and set the format to yellow fill. The exact dialog depends on the rule you choose. Test it with a value that should match and one that should not.

Will yellow fill change a cell’s value or formula?
No. Fill Color changes the cell’s appearance, not its contents. The number, text, date, or formula remains as it was. If a value appears to change, check that you did not type over the cell or apply a number format instead.

Why can I see yellow on screen but not in a printout?
Printer settings, draft or grayscale printing, and pale shades can make yellow difficult to see. Check File > Print and review the preview, then adjust printer settings or choose a stronger fill if appropriate. Add a label or border as a backup when the highlight carries important meaning.

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.