Color of Comment Flags for Individual Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Orchestriatect - 20 Aug 2007 17:30 GMT

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.

Reply to this Message

Jim Rech - 20 Aug 2007 18:03 GMT

>>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.

Signature

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.

Reply to this Message

David McRitchie - 20 Aug 2007 18:09 GMT

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

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
[quoted text clipped - 6 lines]
> color for the cell) because you can't see the flag. Any help would be
> intensely appreciated.

Reply to this Message

Jim Rech - 20 Aug 2007 20:08 GMT

>>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.

Signature

Jim

| Cell Comment indicator triangle, change color of, Stratos Malasiotis,
| 2000-07-08
[quoted text clipped - 22 lines]
| > color for the cell) because you can't see the flag. Any help would be
| > intensely appreciated.

Reply to this Message