How to Change Note Color in Excel for Easier Scanning

How-to basics · Updated November 20, 2026

To change a note’s color in Excel for Microsoft 365 on Windows, right-click its cell, choose Edit Note, right-click the note’s border, and select Format Comment. In the dialog, open Colors and Lines, choose a fill color, and select OK. This changes the background of a classic Excel note; threaded comments have different controls and cannot be recolored this way.

Using different note colors can make important reminders easier to spot, or help distinguish types of information such as follow-ups, definitions, and review notes. The color change applies to the selected note, so you can format notes individually without changing the worksheet’s cell colors. Before you start, check that the item is a note rather than a threaded comment, and save your workbook if its information is important.

What You’ll Need

  • Excel desktop for Windows: The instructions below are for Microsoft Excel for Microsoft 365 on Windows. A desktop version of Excel is recommended because it provides the full note-formatting dialog.
  • A cell containing a note: Notes are the older, typically single-author annotations attached to cells. In recent Excel versions, threaded discussions are called comments.
  • Edit access: If the workbook or worksheet is protected, you may need permission to edit the note or unprotect the sheet first.

Step-by-Step

  1. Identify the item as a note. Select the cell and look for the annotation. In Microsoft 365, notes and comments are separate features: a note is a legacy annotation, while a comment is a threaded conversation with replies. You can also look on the Review tab. The Notes controls apply to notes; the comment controls apply to threaded comments. The fill-color instructions below will not recolor a threaded comment.
  2. Open the note for editing. Right-click the cell containing the note and choose Edit Note. Depending on the Excel build and context menu, the command may be labeled Edit Note or be available from Review > Notes > Edit Note. If you do not see the note box, make sure you have selected the cell that actually contains the note.
  3. Select the note’s border, not its text. When the note is visible, move the pointer to its outline and right-click the border. A selection handle or outline indicates that the note object is selected. If you right-click inside the text, Excel may show editing and text-selection commands instead of formatting options.
  4. Open the formatting dialog. Choose Format Comment from the menu. Excel may retain this older dialog name even though the feature is now called a note. If the menu does not show that command, click the border once to select the note object and try right-clicking the border again.
  5. Choose a fill color. In the dialog, select the Colors and Lines tab. Under Fill, open the Color list and choose a color. The fill is the note box’s background; the line settings control its outline. Use a light background if the note contains several lines of text, so the text remains easy to read.
  6. Apply the change. Select OK to close the dialog. The selected note should now show the new background color. Click another cell to finish editing and check that the note remains readable when displayed.
  7. Repeat for other notes if needed. Excel’s format change applies to the note you selected, not automatically to every note in the workbook. Repeat the process for each note you want to recolor. If several notes need a consistent style, choose the same fill color for each and check them at normal worksheet zoom.

You can also use the ribbon to reveal or edit a note: select its cell, then go to Review > Notes and choose the relevant command, such as Edit Note or Show/Hide Note. The ribbon is useful when the note is difficult to open from the cell itself. The color change, however, is made from the note object’s formatting dialog, not from the cell fill-color button on the Home tab.

Common Mistakes

  • Trying to recolor a threaded comment. Threaded comments are conversation cards, not legacy note boxes. Their display and controls differ, and the classic Format Comment dialog does not set a threaded comment’s background. If you need a colored annotation, use a note where appropriate, or use another visual cue such as a cell fill or a clearly labeled status column.
  • Changing the cell color instead of the note color. The fill-color tool on Home changes the worksheet cell. It does not change the note box. Open the note’s own formatting dialog and set the fill under Colors and Lines.
  • Right-clicking the note text. This may open text-editing options and hide the command you need. Right-click the outline of the visible note so Excel treats it as an object.
  • Expecting every note to change at once. Formatting one note does not set a workbook-wide default. Check each note you want to restyle; otherwise, notes can remain in different colors.
  • Choosing a color with poor contrast. A strong or dark fill can make note text hard to read. Avoid relying on color alone to communicate meaning, especially when the workbook will be printed or viewed by people with color-vision differences.
  • Confusing the note’s fill with its border. The fill changes the box background. A separate line or outline setting changes the border. If the background still looks unchanged, verify that you selected the fill color rather than a line color.

Tips

  • Use a simple color system. For example, reserve pale yellow for general reminders and pale blue for reference information. Add a short legend in the worksheet if other people need to understand what the colors mean.
  • Keep the text readable. Pale fills with dark text usually work well. If a note is dense, consider shortening it or dividing the information among cells rather than making the fill more saturated.
  • Use colors as a supplement, not the only signal. Include words such as “Review” or “Action needed” in the note when the distinction matters. That way, the meaning is still clear in a monochrome printout or for someone who does not distinguish the colors easily.
  • Check the note at the size people will use. A color that looks subtle at high zoom can be hard to distinguish in a busy worksheet. Review the result at a typical zoom level and, if relevant, in Print Preview.
  • Keep a copy before major cleanup. A single formatting change is easy to repeat, but if you are restyling many annotations, save a copy first. This gives you a safe version to return to if the workbook’s appearance becomes inconsistent.

Troubleshooting

  • “Format Comment” is missing: Confirm that you opened a note and are right-clicking its border, not the worksheet cell or the note text. Select Edit Note first, click the outline, and open the context menu again. If the item is a threaded comment, the classic note-formatting command will not appear.
  • The color option is unavailable or the change will not stick: Check whether the worksheet is protected. If you have permission, use Review > Unprotect Sheet, make the change, and protect the sheet again if required. A password-protected sheet requires the password or help from its owner.
  • The note is not visible: Select the cell and use Review > Notes > Show/Hide Note, or choose Edit Note. A note can be hidden without being deleted. If the cell has no note, Excel cannot display the note-formatting options.
  • You are using Excel for the web: The browser version does not offer the same full classic note-formatting dialog as Excel desktop. Open the workbook in the desktop app and follow the Windows steps. If you are working on a Mac, use the desktop app and check the note’s context menu; labels and dialog layout can differ by version. If the color controls are not available in your build, open the workbook in Excel for Windows to format the note.
  • The note color looks unchanged: Reopen the note and confirm its fill color in Format Comment > Colors and Lines. Make sure the chosen color is not the same as the worksheet background, and confirm the note object—not just its text—is selected. Close the dialog with OK to apply the setting.

If the workbook is shared, remember that another editor may change the note’s formatting later. If a color scheme is important to the worksheet’s workflow, document it in the sheet and ask collaborators to keep the conventions consistent.

Frequently Asked Questions

Can I change the color of all notes in a worksheet at once?

Excel does not provide a standard worksheet-wide command to recolor every note at once. The usual approach is to format each note separately using its Format Comment dialog. If there are many, work through the relevant cells systematically and check each result.

Does changing a note’s color change the cell’s fill?

No. The note background and the worksheet cell fill are separate formatting settings. Use the note’s Colors and Lines settings to recolor its box, and the Home tab’s fill control to recolor the cell itself.

Can I change the color of a threaded comment?

Not with the classic note-formatting dialog. Threaded comments are designed as conversations and do not use the same fill-color controls as legacy notes. If you need to highlight information on the sheet, consider a note, a cell color, or another accessible visual indicator.

Will the note color appear when I print the worksheet?

The note’s fill may appear when the note itself is displayed or included in print settings, but printing depends on how notes are set to print and on the printer. Check Page Layout > Page Setup options and use Print Preview to confirm what the printed pages will show.

Can I change a note’s color in Excel for Mac?

Excel for Mac includes notes, but commands and dialog layouts can vary between versions. Try editing the note, selecting its border, and opening the formatting command from its context menu. If your version does not offer the fill controls, use Excel for Windows to make the change.

Why does my note still appear in the old color?

The note may not have been selected as an object, the fill setting may not have been changed, or the dialog may have been closed without applying the choice. Edit the note again, right-click its border, choose Format Comment, set the fill under Colors and Lines, and select OK.

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.