When you add a comment to a cell, Excel automatically uses the Tahoma style font in size 9 on a PC, and size 10 on a Mac. You can change the formatting for a comment, and in Windows you can also or change the default format for all comments.

After installing Kutools for Excel, please follow the following steps to change the comment formats: 1. Format one comment with the style that you want to apply to other comments. 2. Click Kutools > More > Format Comments, see screenshot: 3. In the

Excel 2016 2013 2010 2007 2003. ... In the Format Comment dialog box, on the Colors and Lines tab, click the Color drop-down list and select Fill Effects: 4.