![]() |
#1
|
|||
|
|||
![]()
Hello-I have some experience with VBA in excel however i am new to VBA in word. I am trying to perform conditional formatting on the whole row within a Table in word report that i am creating.
I have multiple tables within this word document however i need to perform conditional formatting on Table (4). Table(4) has 5 rows and 4 columns. I need to loop through starting from Row 2 and check if the cell value in column 3 is 5 and value in column 4 is A. If this condition is true for that particular row then this whole row should be colored Red. I prepared the code below but keep getting "Compile Error: Method or data member not found" on Line 8 Line 1 Sub Demo() Line 2 Dim Rng As Range Line 3 Dim rw As Integer Line 4 Set Rng = ActiveDocument.Content Line 5 With ActiveDocument.Tables(4) Line 6 For rw = 2 To 5 Line 7 If .Cell(rw, 4).Range.Text = "5" And .Cell(rw, 5).Range.Text = "A" Then Line 8 .Range.Cell(rw).Shading.BackgroundPatternColorInde x = wdDarkRed Line 9 End If Line 10 Next Line 11 End With Line 12 End Sub Any help with this VBA code will be really helpful. Any help with this VBA code will be really helpful. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to run colour conditional formatting in just column, not whole table | KateWord | Word VBA | 2 | 09-12-2019 05:30 AM |
Must use VBA to achieve conditional formatting along with expanding table columns? | tinfanide | Excel | 0 | 06-10-2015 12:25 AM |
![]() |
daviieejay | Word VBA | 21 | 12-07-2014 11:08 PM |
![]() |
tinfanide | Excel | 3 | 10-07-2014 10:00 AM |
Conditional Formatting: How to dynamically apply to an expanding table? | tinfanide | Excel | 0 | 10-18-2013 06:34 AM |