Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need feature to change font size default in COMMENT boxes. GED01 Excel Discussion (Misc queries) 1 April 3rd 06 02:20 PM
How do I change the default format for a comment? L4dy_L33l00 Excel Discussion (Misc queries) 1 January 7th 05 01:22 AM
Where to stick macro to change default comment font? [email protected] Excel Discussion (Misc queries) 1 January 1st 05 12:57 AM
Can I change the comment default font stp_paul Excel Discussion (Misc queries) 4 December 30th 04 04:18 PM
change the default word in the insert comment option in excel excel Setting up and Configuration of Excel 2 December 24th 04 12:51 PM


All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"