I am trying to show how far along a certain item is by changing a comment
indicator from the standard red to say Green or orange or any other colour.
i'm using a reqular comment for items at a ceratin stage so colour
recognition would make this easier, instead of reading every comment or
displaying every comment.

Answer and code supplied by Debra Dalgleish:

There's no setting that changes the comment indicator colour. As a
workaround, you can draw triangular shapes over the indicators, and fill
them with a different colour. There's sample code he

http://www.contextures.com/xlcomments03.html#Indicator


"Ady" wrote:

I am trying to show how far along a certain item is by changing a comment
indicator from the standard red to say Green or orange or any other colour.
i'm using a reqular comment for items at a ceratin stage so colour
recognition would make this easier, instead of reading every comment or
displaying every comment.