Is it possible to change the color of the little triangles at the top right
corner of individual cells that indicate someone has placed a comment on the
cell? They're currently red, but that becomes a problem when the cell has to
be colored red (and, no, it's unfortunately not possible to use a different
color for the cell) because you can't see the flag. Any help would be
intensely appreciated.

>>no, it's unfortunately not possible to use a different color for the cell

No, it's unfortunately not possible to use a different color for a cell
comment.

--
Jim
"Orchestriatect" <(E-Mail Removed)> wrote in message
news:16B48E25-C095-4854-9832-(E-Mail Removed)...
| Is it possible to change the color of the little triangles at the top
right
| corner of individual cells that indicate someone has placed a comment on
the
| cell? They're currently red, but that becomes a problem when the cell has
to
| be colored red (and, no, it's unfortunately not possible to use a
different
| color for the cell) because you can't see the flag. Any help would be
| intensely appreciated.

Cell Comment indicator triangle, change color of, Stratos Malasiotis,
2000-07-08
http://google.com/groups?threadm=396....warwick.ac.uk
Also check out another macro doing same thing, mainly by Dave Peterson,
2003-04-25.
http://google.com/groups?threadm=eJu...TNGP10.phx.gbl

I have those links on my pages
Cell Comments
http://www.mvps.org/dmcritchie/excel...ent.htm#colors

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Orchestriatect" <(E-Mail Removed)> wrote ...
> Is it possible to change the color of the little triangles at the top
> right
> corner of individual cells that indicate someone has placed a comment on
> the
> cell? They're currently red, but that becomes a problem when the cell has
> to
> be colored red (and, no, it's unfortunately not possible to use a
> different
> color for the cell) because you can't see the flag. Any help would be
> intensely appreciated.

>>Cell Comment indicator triangle, change color of,

Just to clarify, these approaches cover the comment indicator with a shape,
they don't actually change the comment indicator color. Lots of drawbacks
like the comment doesn't pop up when you mouse over nor adjust correctly
when you change column widths.

--
Jim
"David McRitchie" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
| Cell Comment indicator triangle, change color of, Stratos Malasiotis,
| 2000-07-08
| http://google.com/groups?threadm=396....warwick.ac.uk
| Also check out another macro doing same thing, mainly by Dave Peterson,
| 2003-04-25.
| http://google.com/groups?threadm=eJu...TNGP10.phx.gbl
|
| I have those links on my pages
| Cell Comments
| http://www.mvps.org/dmcritchie/excel...ent.htm#colors
|
| --
| HTH,
| David McRitchie, Microsoft MVP -- Excel
| My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
|
| "Orchestriatect" <(E-Mail Removed)> wrote ...
| > Is it possible to change the color of the little triangles at the top
| > right
| > corner of individual cells that indicate someone has placed a comment on
| > the
| > cell? They're currently red, but that becomes a problem when the cell
has
| > to
| > be colored red (and, no, it's unfortunately not possible to use a
| > different
| > color for the cell) because you can't see the flag. Any help would be
| > intensely appreciated.
|