View Single Post
 
Old 04-28-2019, 11:25 AM
JohnWilson JohnWilson is offline Windows 10 Office 2016
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,913
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default

This should do it:

Code:
Sub ChangeTextColors()

Dim oSl As Slide
Dim oSh As Shape
Dim lRow As Long

For Each oSl In ActivePresentation.Slides
For Each oSh In oSl.Shapes
If oSh.HasTable Then
With oSh.Table
For lRow = 1 To .Rows.Count
With .Cell(lRow, 1).Shape
If .HasTextFrame Then
If .TextFrame.HasText Then
If UCase(.TextFrame.TextRange) = "YES" Then
.TextFrame.TextRange.Font.Color.RGB = RGB(255, 0, 0)
End If
End If
End If
End With
Next lRow
End With
End If
Next oSh
Next oSl
End Sub
__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote