![]() |
|
#4
|
||||
|
||||
|
You could use something like:
Code:
Sub ConditionalHighlight()
Application.ScreenUpdating = False
Dim vFindText As Variant, StrWrds As String, i As Long
vFindText = "Note,Notes"
vFindText = Split(vFindText, ",")
StrWrds = ",The,Each,"
For i = LBound(vFindText) To UBound(vFindText)
With ActiveDocument.Range
With .Find
.ClearFormatting
.Replacement.ClearFormatting
.Forward = True
.Format = False
.MatchWildcards = True
.Wrap = wdFindStop
.Text = "<[! ]{1,}> " & vFindText(i) & ">"
.Replacement.Text = ""
.Execute
End With
Do While .Find.Found
If InStr(StrWrds, "," & Trim(.Duplicate.Words.First.Text) & ",") > 0 Then
.Duplicate.HighlightColorIndex = wdBrightGreen
End If
.Collapse wdCollapseEnd
.Find.Execute
Loop
End With
Next i
Application.ScreenUpdating = True
End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Find - Replace Macro using a table list | mdw | Word | 0 | 08-01-2013 04:36 PM |
Find and Replace Format macro issue
|
Jack | Word VBA | 2 | 12-12-2012 09:24 PM |
| macro or find/replace | JamesVenhaus | Word | 2 | 02-27-2012 03:34 PM |
Complex Find and Replace
|
paulkaye | Word | 1 | 11-13-2011 04:23 AM |
| Find and Replace Macro - A Better Way | Tribos | Word VBA | 0 | 10-08-2008 03:22 AM |