How to save font color to use in a VBA macro

[GAmanda]

I am trying to automate the changing of the font color instead of selecting and then applying the font color from the ribbon.



I'm hoping that I can do this in a macro. I know how to select what I need to change. The problem I have is applying the font color as this will be in a template, so the color can change from document to document based on this template. The color of the whole document is black, but there are several times through out the document were I need to change the font color of certain words or phrases.

Is there a way to either get whatever the color of the font button on the ribbon is or to set this color, which usually would be a custom color, to a variable which I then could apply using with selection.font?

[gmayor]

Create a paragraph or character style as appropriate that has the colour settings you require then apply it to the text in question.