Color of Comment Flags

[sue t]

Hi
Is there anyway of going into any settings and changing
the red flags in the cells that hold comments from red to
another color?

Thank You

 

[Jim Rech]

I don't believe that's possible, sorry.

--
Jim Rech
Excel MVP
| Hi
| Is there anyway of going into any settings and changing
| the red flags in the cells that hold comments from red to
| another color?
|
| Thank You

 

[David McRitchie]

There was a creative solution to create a triangle shape
with another color and overlay that over the comments
but I doubt that it is worth the trouble for most people.
http://www.mvps.org/dmcritchie/excel/ccomment.htm

Here is a link to overlaying a shape over the triangle
it appears to have started with something from DavePeterson
http://google.com/[email protected]

Just in case you are not aware, later versions have
different colors with different meanings in different corners.
You might be creating additional problems by the deception.
http://www.mvps.org/dmcritchie/excel/colors.htm#triangles
--

 

[David McRitchie]

Hi Sue,
Actually there was an earlier use of a triangle shape overlaying
the cell comment to change the apparent color, you might want to
check out both threads instead of just one of them.

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]