How to Change Comment Color in Excel: 3 Suitable Examples

Method 1 – Using the Format Comment Option from Context Menu

Steps

We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
If the mark is over 80, then the score will be Satisfactory.
If the score is between 60-80, the comment will be Moderate.
If the score is less than 60, the comment will be Not Satisfied.

Using Format Comment Option from Context Menu to change comment color in Excel

Right-click on the first comment, and from the context menu, click Format Comment.

In the window named Format Comment, select font Tahoma.
Use Bold Italic in the Font Style.
Select 14 as the Size option.
Change the color to Dark Blue.
Click OK.

The first comment’s color has changed to deep blue as we formatted it in the previous step.

Repeat the same process for the other comments.

Method 2 – Utilizing the Edit Note Option from the Context Menu

Steps

We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
If the mark is over 80, then the score will be Satisfactory.
If the score is between 60-80, then the comment will be Moderate.
If the score is less than 60, the comment will be Not Satisfied.

Right-click on the cell and click on the Edit Note from the context menu.

After clicking the Edit Note, we can see that the comment is now visible.
Select the comment, and then from the context menu, click Format Comment.

In the Format Comment window, select font Tahoma.
Use Bold Italic in the Font Style.
Select 14 as the Size option.
Change the color to Dark Blue.
Click OK.

After clicking OK, you will see that the comment color has changed to Dark Blue.
Repeat the same process for the rest of the comments.
The final output will look like the below image.

Method 3 – Changing the Comment Indicator Color

Steps

We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
If the mark is over 80, then the score will be Satisfactory.
If the score is between 60-80, the comment will be Moderate.
If the score is less than 60, the comment will be Not Satisfied.
The comment indicator is Black. We need to change this color to green.

Go to the Developer tab and select Visual Basic.

You’ll get the Microsoft Visual Basic window.
Go to Insert > Module.

In the editor window, paste this code.

Sub Comment_Color()
Dim x As Worksheet
Dim y As Comment
Dim z As Range
Dim m As Shape
Set x = Application.ActiveSheet
wShp = 6
hShp = 4
For Each y In x.Comments
Set z = y.Parent
Set m = x.Shapes.AddShape(msoShapeRightTriangle, z.Offset(0, 1).Left - wShp, z.Top, wShp, hShp)
With m
.Flip msoFlipVertical
.Flip msoFlipHorizontal
.Fill.ForeColor.SchemeColor = 12
.Fill.Visible = msoTrue
.Fill.Solid
.Line.Visible = msoFalse
End With
Next
End Sub