Word if the value is higher than $30,000 then highlight Turquoise.

Question

Hello from Steve

In a word document is it possible please, if the value is higher than $30,000 then highlight Turquoise VBA

Answer 1

This should get you started:

Sub HighlightValuesOver30000()
    Dim rng As Range
    Dim findRange As Range
    Dim numValue As Double
    
    ' Start from the beginning of the document
    Set rng = ActiveDocument.Content
    rng.Find.ClearFormatting
    rng.Find.Replacement.ClearFormatting
    
    ' Search for numbers (including commas and decimals)
    With rng.Find
        .Text = "<[0-9,\.]{1,}>"
        .MatchWildcards = True
        .Forward = True
        .Wrap = wdFindStop
    End With
    
    ' Loop through all matches
    Do While rng.Find.Execute
        Set findRange = rng.Duplicate
        
        ' Remove commas for numeric conversion
        On Error Resume Next
        numValue = CDbl(Replace(findRange.Text, ",", ""))
        On Error GoTo 0
        
        ' Check if number is greater than 30000
        If numValue > 30000 Then
            findRange.HighlightColorIndex = wdTurquoise
        End If
        
        ' Move to next match
        rng.Collapse wdCollapseEnd
    Loop
    
    MsgBox "Highlighting complete.", vbInformation
End Sub

Answer 2

Word does not support conditional formatting of text based on numeric values in the way that Excel does, so it cannot automatically highlight values greater than $30,000 in turquoise purely by rule.

However, text can be manually highlighted in turquoise (or programmatically via an add-in or script):

1. Select the value(s) to highlight.
2. On Windows desktop Word, go to Home and select the arrow next to Text Highlight Color.
3. Choose Turquoise from the available highlight colors.

If using a Word JavaScript add-in, the highlight color can be set in code, for example:

await Word.run(async (context) => {
  const selection = context.document.getSelection();
  // After programmatically determining the value > 30000,
  // apply turquoise highlight to the selection
  selection.font.highlightColor = 'Turquoise';
  await context.sync();
});

Note that only the built‑in highlight colors (including "Turquoise") are available in Office for Windows Desktop; other colors are mapped to the closest available color.

---

References:

• Apply or remove highlighting
• Word.Font class
• Word.Interfaces.FontData interface
• Word.Interfaces.FontUpdateData interface