![]() |
|
#1
|
||||
|
||||
![]() Maybe something like the following. Note the search is case sensitive. Code:
Sub Macro1() Dim oTable As Table Dim oCell As Range Dim i As Long For Each oTable In ActiveDocument.Tables For i = 1 To oTable.Range.Cells.Count Select Case True Case InStr(1, oTable.Range.Cells(i).Range.Text, "Science") > 0 Set oCell = oTable.Range.Cells(i).Range oCell.End = oCell.End - 1 oCell.Font.Color = wdColorGreen Case InStr(1, oTable.Range.Cells(i).Range.Text, "Health") > 0 Set oCell = oTable.Range.Cells(i).Range oCell.End = oCell.End - 1 oCell.Font.Color = wdColorRed 'etc End Select Next i Next oTable lbl_Exit: Set oTable = Nothing Set oCell = Nothing Exit Sub End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Kubi | Excel | 4 | 08-24-2017 05:53 PM |
VBA to immediately change the colour of a cell depending on the code placed in anothe | Phil Payne | Excel Programming | 2 | 07-27-2013 11:04 PM |
![]() |
RoyLittle0 | Excel | 2 | 05-05-2013 12:50 AM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |