change comment marker in Excel

[Jo]

I have created a chart in Excel so I can use comments like pop-up/hover text
boxes to describe the elements on the chart. Now I want to change the
appearance of the comment marker. Can you help me do that?

 

[Gord Dibben]

By "Chart" do you mean a graphical chart?

Is this chart on the sheet or is it a separate Chart Sheet?

How did you create the Comments on the chart?


Gord Dibben MS Excel MVP

 

[Jo]

Sorry, I shouldn't have used the word "chart". It's only a worksheet (but it
won't be used as a spreadsheet). I have inserted hidden comments and
formatted them as large text boxes.

 

[Gord Dibben]

How did you insert "hidden" comments and format them as large text boxes?

Do you mean you just inserted a Comment in a cell using Insert>Comment and
entered text in that Comment?

The red triangle in top right corner of the cell indicating it has a Comment
cannot be changed to another color.

If you don't like the color or don't want to see the marker, you could use a
Data Validation Input Message instead of a Comment.

Only problem with that method is you have to select the cell to see the message.

Or you could use the drawing toolbar to place a colored shape over the red
marker.

Make sure to set its properties to resize and move with cells.


Gord

 

[Jo]

Thanks Gord. The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour). I
like your idea of hiding it with a drawing object, given it's not able to be
individually formatted. Thanks for your help.

 

[Gord Dibben]

I don't understand this statement.............

"The colour of the marker did actually change when I
reformatted the fill colour of the comment box (corresponding colour)"

but happy to hear you're satisfied.


Gord

 

[Jo]

Gee, and I thought I was good with language. I inserted a comment (right
click, insert comment), formatted the comment (highlight comment frame,
format menu, comment) and changed the fill colour. Then I hid the comment
(right click, hide comment). The marker (could also be called a comment
indicator) which remains visible in the corner of the cell which has a
comment inserted, automatically changed to the same colour as the comment
fill colour.