Concatenate two cells, change font color and put in the third column

[susan.stein]

I have the below and I need it to work on the whole file. I want to choose column 1 and column 2 and put it in column three after it adds a line and changes to font in Column 1 to red. Here is what my file looks like, text only:
What is the address of your corporate headquarters? ServiceNow is headquartered at 2225 Lawson Lane, Santa Clara, California 95054.

VBA

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[Bernie Deitrick]

The code worked for me, although it chooses the usedrange of the activesheet initially....

Capture.JPG