If you’re keen to add some snaz to your Cell Comments then read on!
Cell Comments are just Shapes underneath and you can treat them that way!
Ensure you have the Drawing Toolbar visible. From Excel’s menu: View > Toolbars > tick Drawing.
Add a comment to a cell.
While editing the comment, you’ll notice there is a thick striped border around the shape. While you’re typing comment text, you’ve actually got the Textbox selected, not the Shape itself. So you need to select the Shape.
Click the border or simply hit the Tab key. Notice how the thick striped border changes to a dotted pattern.
Now that you’ve got the Shape selected, you can change many properties of the appearance.
eg. From the Drawing toolbar: Draw > Change Autoshape > Stars and Banners > 16 point Star.
Everything you need to alter the appearance of the comment is available from the Drawing toolbar – Shadows, 3D, Colour, etc…