How to highlight rows in Table, at one go, in Microsoft Word, depending upon a criteria

Question

Dear Sir/Madam,

I would like to highlight all the rows in the MS Word document containing word "SPDC-JK", i have highlighted two such rows using "Yellow" interior color, however, i have done this manually.

Kindly note that, the document was initially available in PDF and i have converted it to "Word" document, because converting to "Excel" document, distorts the data-table.

The screenshot is enclosed below:-

As can be observed, i have highlighted with "Red Pen", the word "SPDC-JK", for which i would like to get the "Yellow"color highlighted automatically to the entire row, through some macro or some other MSWORD tool Tip.

There are 31 such instances in this table, which is spread over 7 pages.

If any any clarification or document requested, then please let me know.

Answer 1

If highlighting just the SPDC-JK, you could simply use the Find and Replace feature to find SPDC-JK and then select Highlight All from the Reading Highlight dropdown

To highlight the whole row, it would be necessary to use a macro

Dim i as Long

With Selection.Tables(1)

    For i = 1 To .Rows.Count

        If InStr(.Rows(i).Cells(2).Range.Text, "SPDC-JK") > 0 Then

            .Rows(i).Shading.BackgroundPatternColor = wdColorYellow

        End If

    Next i

End With

Answer 2

Note that "Reading Highlight" is different from actual highlighting. For example, it does not print, and the highlight color cannot be changed.

Answer 3

Dear Sir,

Thanks for the Heads up.

I would like to take print out with "Yellow" color. Will the solution provided by Mr. Doug Robbins, not work in this case and in that case is macro the only solution.

Will macro allow me to get colored printout?

In other words, can we achieve actual highlighting in MSWord?

Kindly let me know.

Regards,

Sandeep

Answer 4

The way I interpret Doug's macro, it adds shading to cells. This formatting is part of the table and it will be printed.

Text Color Highlight will print, but it only applies to the text, not to the table cells.

Reading Highlight, as Suzanne said, is only temporary. It won't be preserved if you save, close and reopen the document, and it won't print.