Link to home
Create AccountLog in
Avatar of Andreas Hermle
Andreas HermleFlag for Germany

asked on

Conditionally apply blue font color to table rows using VBA

Dear Experts:

The following macro (courtesy of the MS Word 'Sage' Graham Skan from EE) applies a blue font color on all table rows where the text entry in the 8th column of the tables is 'blue'

I got a a new requirement:

It is always the last column where this text entry is found. Hence instead of hard coding the 8th column, Line 6 and Line 7 should be tweaked to accomodate the new requirement.

Sub BlueRow()
    Dim tbl As Table
    Dim rw As row
    For Each tbl In ActiveDocument.Tables
        For Each rw In tbl.Rows
            If Len(rw.Cells(8).Range.Text) = 6 Then
                If InStr(1, rw.Cells(8).Range.Text, "blue", vbTextCompare) Then
                    rw.Range.Font.Color = wdColorBlue
                End If
            End If
        Next rw
    Next tbl
End Sub

Open in new window


Help is very much appreciated. Thank you very much in advance.

Regards, Andreas
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
not too sure about the condition:

If Len(rw.Cells(8).Range.Text) = 6 Then

Open in new window

which you may simply remove it.

to become:

Sub BlueRow()
    Dim tbl As Table
    Dim rw As Row
    For Each tbl In ActiveDocument.Tables
        For Each rw In tbl.Rows
            If InStr(1, rw.Cells(rw.Cells.Count).Range.Text, "blue", vbTextCompare) Then
                rw.Range.Font.Color = wdColorBlue
            End If
        Next rw
    Next tbl
End Sub

Open in new window

Avatar of Andreas Hermle

ASKER

Great Ryan, this did the trick, thank you very much for your swift help.

Regards, Andreas