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.

~ April