by Allen Wyatt
(last updated July 28, 2018)
When working with comments, Heather figured out how to change the font color in the comment. She wonders, though, if there is a way to actually change the background (fill) color of the comment.
You can change the fill color of a comment rather easily. To do so, follow these steps:
Figure 1. The Format Comment dialog box
An alternative way to display the Format Comment dialog box is to simply click once on the comment (step 1) and then press Ctrl+1. You can then follow steps 4 through 7, the same as above.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13556) applies to Microsoft Excel 2007, 2010, 2013, and 2016.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Excel allows you to place pictures inside of comments. If you do this, you may have experienced a situation where the ...Discover More
Want your comment boxes to appear someplace other than the right side of a cell? You may be out of luck, and here's why.Discover More
The default color used to format comments is determined by Windows, not Excel. You can adjust the formatting of ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.