Change Paragraph Mark Color and Text Font with a Word VBA Macro
Question details
The user wants a Word macro that colors paragraph marks red and sets document text to 14-point Calibri.

- Product
- Microsoft Word
- Device & OS
- not provided
- Scenario
- Format paragraph marks and document text consistently using VBA.
- Observed behavior
- The desired result is red paragraph marks with document text in 14-point Calibri.
Open the document in a desktop version of Word that supports VBA, and use Home > Show/Hide ¶ to display paragraph marks. The macro below targets the main document body, not headers, footers, or other stories.
Run a VBA macro to format text and paragraph marks
Use this approach to apply both formatting changes to the main document body in one operation.
In desktop Word, open the Developer tab and select Visual Basic. In Word for Windows, you can also press Alt+F11.
In the VBA editor, select Insert > Module and paste this code: Sub FormatParagraphMarks() Dim body As Range Set body = ActiveDocument.Content body.Font.Name = "Calibri" body.Font.Size = 14 Set body = ActiveDocument.Content With body.Find .ClearFormatting .Replacement.ClearFormatting .Text = "^p" .Replacement.Text = "^p" .Replacement.Font.Color = wdColorRed .Forward = True .Wrap = wdFindStop .Format = True .MatchWildcards = False .Execute Replace:=wdReplaceAll End With End Sub
Return to Word, select Developer > Macros, choose FormatParagraphMarks, and select Run. Check the document with Home > Show/Hide ¶ enabled.
To keep the macro in the document, select File > Save As and choose Word Macro-Enabled Document (*.docm).

Use Find and Replace to color paragraph marks without a macro
Use Word's formatting controls if you prefer not to run VBA.
Format Word Documents with WPS Writer
WPS Office is a free, lightweight alternative with a familiar interface for editing Word documents and applying font formatting. Its format compatibility helps you move existing documents into WPS Writer; it does not fix or guarantee support for a Microsoft Word VBA macro.

Frequently Asked Questions
How do I show paragraph marks in Word?
On the Home tab, select Show/Hide ¶ in the Paragraph group. Select it again to hide the marks.
Does the macro also format headers and footers?
No. It uses ActiveDocument.Content, which targets the main document body. Headers, footers, and other stories require separate handling.
Will setting the font to Calibri change the existing text color?
The macro sets the font name and size without explicitly changing the text color. It then applies red to paragraph marks found in the main document body.
Why should I check text typed after a red paragraph mark?
A paragraph mark carries character formatting, which can influence newly typed text. If new text appears red, select it and change its font color from Home > Font Color.
How can I keep the macro for future use?
Use File > Save As and choose Word Macro-Enabled Document (*.docm) if the macro is stored in the document. A standard DOCX file cannot retain VBA macros.




