Excel comment indicator color

Question

In Excel 365, is there a way to have the comment indicator color change when the comment is marked "resolved"?

Answer 1

Hi Chiara_me,

Thank you for posting in this community.

According to my research and tests, I am sorry that I don’t find any out of box ways to do this.

However, I understand the inconvenience caused to you. Given this situation, it’s recommended to send feedback within Word app.

How do I give feedback on Microsoft Office?

Since it is the quickest route to get your comments to the related programming developers’ ears. They read customer feedback daily.

Thank you for your time and understanding.

Best Regards,

May

Answer 2

Hi,

Please check whether the following is helpful:

In the above screenshot:

- there are 4 comments, of which 2 comments (comment 2 & comment 4) are resolved.

- when the following code is executed > in the active sheet > if the comment status is resolved > cell color will be changed to green.

Code

Sub Comment_Color()

Dim CommentLoop As CommentThreaded

For Each CommentLoop In ActiveSheet.CommentsThreaded

If CommentLoop.Resolved = True Then

ActiveSheet.Range(CommentLoop.Parent.Address).Interior.Color = vbGreen 

End If

Next

End Sub

Hope, this helped.

Please respond if You require further support. I will try My Best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!