Setting default formats for color and comments

[LF]

How do I set my color palette as a default so that I don't have to keep changing it in each workbook. And I do set the default formats for Comment texts so that I don't have to keep changing it in each comment. Thanks.

 

[Frank Kabel]

Hi
for your comments question have a look at
http://www.contextures.com/xlcomments02.html#Default

For your color question the following site may help you
http://www.mvps.org/dmcritchie/excel/colors.htm