Hi Everyone!
I'm having a little problem programming comments. I use a database in Microsoft Excel 2003 with a lot of comments. I coded a macro to insert comments in some cells with a standard text heading and some variable information get from a list of cells. The problem is the following: I want to have the first line of text bold and black. the rest of the text inside the comment i want to have it without the bold but in red color. I have nearly 800 comments. I haven't formatted the text manually coz i'll never end. Can you help me please?

Is like to have this inside a comment but without doing it manually (The Record Macro function do not do the trick)
Heading 1
Variable Text 1

All this inside a comment.

Thanks a lot
Alejandro C.