ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to change the color of the triangle indicating a comment (https://www.excelbanter.com/excel-discussion-misc-queries/106196-how-change-color-triangle-indicating-comment.html)

Franciane

how to change the color of the triangle indicating a comment
 
I have to do a sheet and some of the cell have a red background. For some of
those i have to add some comments. I can not have the comments always on. The
fact the the background is the same color as the small triangle indicating
the presence of a comment (in the upper right corner) makes it invisible. I
have not been able the find the way to change the color of that indicator.
Please let me know how to do it.
Thnaks

Debra Dalgleish

how to change the color of the triangle indicating a comment
 
There's no setting that changes the comment indicator colour. As a
workaround, you can draw triangular shapes over the indicators, and fill
them with a different colour. There's sample code he

http://www.contextures.com/xlcomments03.html#Indicator

Franciane wrote:
I have to do a sheet and some of the cell have a red background. For some of
those i have to add some comments. I can not have the comments always on. The
fact the the background is the same color as the small triangle indicating
the presence of a comment (in the upper right corner) makes it invisible. I
have not been able the find the way to change the color of that indicator.
Please let me know how to do it.
Thnaks



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com