ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Color change for comment indicators (https://www.excelbanter.com/setting-up-configuration-excel/132140-color-change-comment-indicators.html)

CarolM

Color change for comment indicators
 
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

Color change for comment indicators
 
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/xlcomme...html#Indicator

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


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:29:05 -0800, CarolM
wrote:

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.



Paul B

Color change for comment indicators
 
"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


"CarolM" wrote in message
...
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.




John

Color change for comment indicators
 
You don't need code for changing error checking indicators.
toolsoptionserror 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)


"Gord Dibben" wrote:

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/xlcomme...html#Indicator

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


Gord Dibben MS Excel MVP

On Fri, 23 Feb 2007 10:29:05 -0800, CarolM
wrote:

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.




CarolM

Color change for comment indicators
 
Dah, you're right--red not green--I will ck out what you suggested.

"Paul B" wrote:

"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


"CarolM" wrote in message
...
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

Color change for comment indicators
 
Aaaarrrrgh!

Forgot all about that change color setting.

Thanks for the reminder.

I'll remember until the next time<g


Gord

On Fri, 23 Feb 2007 15:10:08 -0500, "Paul B"
wrote:

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




All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com