Color of Comment Flags for Individual Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
| 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
| Cell Comment indicator triangle, change color of, Stratos Malasiotis,
| 2000-07-08
| http://google.com/[email protected]
| Also check out another macro doing same thing, mainly by Dave Peterson,
| 2003-04-25.
| http://google.com/[email protected]
|
| I have those links on my pages
| Cell Comments
| http://www.mvps.org/dmcritchie/excel/ccomment.htm#colors
|
| --
| HTH,
| David McRitchie, Microsoft MVP -- Excel
| My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
|
| > 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.
|
 
Back
Top