Comment box font color

[dreicer_Jarr]

Is there a way to set the default font color for the words within the comment boxes to always be red? I have a daily spreadsheet where many comment boxes are added and it does not seem efficient to keep changing the font color manually over-and-over.

Setting the font color for one comment box and then copy and pasting that comment to the next place in need of a comment will not work as I do not want to change the values within the cells that will eventually get comments - if that makes sense? Any help would be appreciated.

[dreicer_Jarr]

For those that are interested, I found the answer myself.

Go outside Excel and use the Windows Display Settings dialog box. You can access the Display Settings dialog box from the Control Panel. Or, you can right-click the desktop and choose Properties. Access the Appearance tab of the Display Properties dialog box, and select the ToolTip item. You can then modify the font, the font size, the background color, the foreground color, and the Bold and Italic attributes. For XP (which is what I have), you have to click the advanced tab once you are on the Appearance tab and then you select the ToolTip item.