Changing the color of the "comment" triangle

Ok, you Excel guru's out there. How do you change the color of the little red
triangle that denotes that a cell has a comment in it? I have some cells with
a red fill color on my spreadsheet that I want to put comments in, but the
little red triange that denotes a cell having comments doesnt show up against
the red fill. Anyone know how to change the little red triangle to other
colors?

Hi Mike,
You can't change the color, you can create a shape and overlay it.
I'd not recommend it, but there must be quite a few people who are
doing that. This reply post from Dave Peterson
http://groups.google.com/groups?thre...24D3%40msn.com

You might not be aware of other color triangles in other corners
Colors used in Cell Comments (#colors)
http://www.mvps.org/dmcritchie/excel...ent.htm#colors
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Mike" <[email protected]> wrote in message news:[email protected]...
> Ok, you Excel guru's out there. How do you change the color of the little red
> triangle that denotes that a cell has a comment in it? I have some cells with
> a red fill color on my spreadsheet that I want to put comments in, but the
> little red triange that denotes a cell having comments doesnt show up against
> the red fill. Anyone know how to change the little red triangle to other
> colors?

You cannot change the color of the Comment indicator.

You can change the fill color of the red cells or opt to not show comment
indicators and draw a black triangle on the cells with comments.


Gord Dibben MS Excel MVP

On Sun, 20 Aug 2006 08:13:01 -0700, Mike <[email protected]> wrote:

>Ok, you Excel guru's out there. How do you change the color of the little red
>triangle that denotes that a cell has a comment in it? I have some cells with
>a red fill color on my spreadsheet that I want to put comments in, but the
>little red triange that denotes a cell having comments doesnt show up against
>the red fill. Anyone know how to change the little red triangle to other
>colors?

Gord Dibben wrote

> or opt to not show comment indicators

How? Is this available in XL2000?

--
David

Display
tools, options, view, comments: none

Print,
Page Setup, sheet, print comments: none
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"David" <[email protected]> wrote in message news:[email protected]...
> Gord Dibben wrote
>
> > or opt to not show comment indicators
>
> How? Is this available in XL2000?
>
> --
> David

Thanks, I took it literally to mean not to show the indicators, but still
show the comment itself.

--
David

David McRitchie wrote

> Display
> tools, options, view, comments: none
>
> Print,
> Page Setup, sheet, print comments: none
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "David" <[email protected]> wrote in message
> news:[email protected]...
>> Gord Dibben wrote
>>
>> > or opt to not show comment indicators
>>
>> How? Is this available in XL2000?
>>
>> --
>> David
>
>
>

That was me leading you astray originally with "opt to not show indicator"

Sorry about that.


Gord Dibben MS Excel MVP

On Mon, 21 Aug 2006 00:11:26 -0700, David <[email protected]> wrote:

>Thanks, I took it literally to mean not to show the indicators, but still
>show the comment itself.