Microsoft Office Forums - View Single Post - [Solved] Formatting information with a specified status

macropod · 04-05-2017, 02:45 PM

Assuming the data you want to work on are in the tables, you could use a macro like:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim Tbl As Table, r As Long
For Each Tbl In ActiveDocument.Tables
  With Tbl
    .Shading.BackgroundPatternColorIndex = wdGray25
    For r = .Rows.Count To 2 Step -1
      If Split(.Cell(r, 1).Range.Text)(0) = "rejected" Then .Rows(r).Delete
    Next
  End With
Next
Application.ScreenUpdating = True
End Sub