Color change for comment indicators

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CarolM - 23 Feb 2007 18:29 GMT

I know that at one time I changed the color of comment indicators in
Excel--but can't find the instructions now. A friend needs a color other
than green. Thanks for any assistance that you can give.

Reply to this Message

Gord Dibben - 23 Feb 2007 20:01 GMT

Carol

Comment indicators are red.

Perhaps you are referring to error-checking indicators which are green.

Comment indicators cannot and never could be changed without code

You can overlay Comment indicators with triangles created using the drawing
toolbar.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xlcomments03.html#Indicator

Don't know if code is available for changing the error-checking indicators.

Gord Dibben MS Excel MVP

>I know that at one time I changed the color of comment indicators in
>Excel--but can't find the instructions now. A friend needs a color other
>than green. Thanks for any assistance that you can give.

Reply to this Message

john - 23 Feb 2007 20:14 GMT

You don't need code for changing error checking indicators.
tools>options>error checking and choose the colour you want

Signature

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

> Carol
>
[quoted text clipped - 18 lines]
> >Excel--but can't find the instructions now. A friend needs a color other
> >than green. Thanks for any assistance that you can give.

Reply to this Message

Paul B - 23 Feb 2007 20:10 GMT

"Carol,

I don't think that Excel provides a way to change the color of comment
indicators, but I thought they were red.

But have a look here for a work around

http://tinyurl.com/33uwdn

Error checking indicators are green, could it be those instead? If so tools,
options, error checking and change it from there

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

>I know that at one time I changed the color of comment indicators in
> Excel--but can't find the instructions now. A friend needs a color other
> than green. Thanks for any assistance that you can give.

Reply to this Message

CarolM - 23 Feb 2007 21:20 GMT

Dah, you're right--red not green--I will ck out what you suggested.

> "Carol,
>
[quoted text clipped - 11 lines]
> > Excel--but can't find the instructions now. A friend needs a color other
> > than green. Thanks for any assistance that you can give.

Reply to this Message

Gord Dibben - 23 Feb 2007 23:45 GMT

Aaaarrrrgh!

Forgot all about that change color setting.

Thanks for the reminder.

I'll remember until the next time<g>

Gord

>Error checking indicators are green, could it be those instead? If so tools,
>options, error checking and change it from there

Reply to this Message