Color change for comment indicators

[CarolM]

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.

 

[Gord Dibben]

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

 

[Paul B]

"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


--
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

 

[john]

You don't need code for changing error checking indicators.
tools>options>error checking and choose the colour you want
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[CarolM]

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

 

[Gord Dibben]

Aaaarrrrgh!

Forgot all about that change color setting.

Thanks for the reminder.

I'll remember until the next time<g>


Gord