EditComment
Right-click on Comment Border and Format Comment
Choose the color you want.
To change the default InsertComment background color requires you go into
WindowsAppearance Settings.
See Debra Dalgleish's site for more specifics on Comments.
http://www.contextures.on.ca/xlcomments01.html
Note she has some code for formatting Comments backgrounds.
Gord Dibben MS Excel MVP
On Tue, 12 Jan 2010 08:26:01 -0800, Bill Craig
wrote:
How does one format the background color of a comment. I inherited a
spreadsheet recently, and the existing comments have a yellow background and
mine have white.
I want to change the yellow background to white to match the rest of the
comments.
(I know I could delete and re-create the yellow-background comments, but it
seems so inefficient.)