![]() |
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. |
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. |
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. |
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. |
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. |
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