If you use comments in MS Excel then you might find yourself wishing that there was a way to color code them.
Maybe some comments are notes you’ve made to yourself about double checking a formula, maybe others pertain to something entirely different.
Whatever your needs it might interest you to know that you can change the color of your comments with just a couple a clicks.
Once you’ve located a comment to be changed simply right-click on the border of the comment.
Then choose Format Comment from the menu.
When the dialog window opens choose the Colors and Lines tab.
At this point it’s a quick decision as to what color to choose and a click on the OK button.
And there you have it – comments of any color you choose.