We use comments in Excel sheets for various reasons, for better clarity, marking down important notes, etc. But the default mode of the comment format is pretty dull and thus requires reformatting. If you are curious about how you can change the comment color in Excel, then this article may come in handy for you. In this article, I am going to show how you can change the comment color in Excel with an elaborate example.
How to Change Comment Color in Excel: 3 Suitable Methods
Below, we presented 3 separate examples to show how we can change the color of the comments in Excel Sheets. The dataset used here is actually the marks of three separate students. Additionally, three more comments were also made on their score. To avoid any kind of compatibility issues, use Excel 365 edition.
1. Using Format Comment Option from Context Menu
Using the context menu’s Format Option, we can format and change the color of the comment text pretty easily.
Steps
- We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
- For example, if the mark is over 80, then the score will be Satisfactory.
- Then if the score is between 60-80, then the comment will be Moderate.
- Finally, if the score is less than 60, the comment will be Not Satisfied.
- Now, right-click on the first comment, and from the context menu, click on click on Format Comment.
- In the window named Format Comment, select font Tahoma.
- And Bold Italic in the Font Style.
- Select 14 as the Size option.
- Finally, change the color to Dark Blue.
- Click on OK after this.
- After clicking OK, we can see that the first comment color has changed to deep blue as we formatted it in the previous step.
- Repeat the same process for the other comments.
Read More: How to Change Default Comment Font Size in Excel
2. Utilizing Edit Note Option from Context Menu
Here, using the Edit Note option from the context menu, we can change the color of the text in Excel sheet comments. This process is quite straightforward and demands no prior knowledge of something new.
Steps
- We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
- For example, if the mark is over 80, then the score will be Satisfactory.
- Then if the score is between 60-80, then the comment will be Moderate.
- Finally, if the score is less than 60, the comment will be Not Satisfied.
- For this, right-click on the cell and click on the Edit Note from the context menu.
- After clicking on 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.
- And Bold Italic in the Font Style.
- Select 14 as the Size option.
- Finally, change the color to Dark Blue.
- Click on OK after this.
- 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.
Read More: How to Reset Comment Position in Excel
3. Changing Comment Indicator Color
Using a simple VBA macro code, we can easily change the color of the comment indicator in Excel sheet comments. This process is simple and time-saving compared to other methods available.
Steps
- We have comments presented for the marks obtained by each of the students in the range of cells C5:C7.
- For example, if the mark is over 80, then the score will be Satisfactory.
- Then if the score is between 60-80, then the comment will be Moderate.
- Finally, if the score is less than 60, the comment will be Not Satisfied.
- Moreover, we can notice that the comment indicator is now Black color.
- We need to change this color to green.
- Then go to the Developer tab > Visual Basic.
- After clicking on Visual Basic, we can see that there is a window open For Microsoft Visual Basic.
- Go to Insert > Module.
- In the editor window, paste this below 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
- After inputting the code, close the editor window.
- Go to View tab > Macros > View Macros.
- In the Macros window, click on Comment_Color.
- And then click on OK.
- After this, you will notice that the comment indicators now turned Blue.
Read More: How to Change Author Name in Excel Comments
Download Practice Workbook
Download this practice workbook below.
Conclusion
To sum it up, the issue of how we can change the comment color in Excel is shown here with 3 different examples. For this problem, a workbook is available to download where you can practice these methods. Feel free to ask any questions or feedback through the comment section.
