![]() |
|
|
|
#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 |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
count the number of text in a cell based off a different cells text
|
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 |
Quadrant colour based on cell value
|
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 |