View Single Post
 
Old 08-09-2017, 12:51 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jul 2017
Posts: 89
kevinbradley57 is on a distinguished road
Default

Paul -- Can you show me how to change the font color to white when the text = "High"?

Case "Risk"
Select Case .Range.Text
Case "High": .Range.Cells(1).Shading.BackgroundPatternColor = 4739264
Case "Moderate": .Range.Cells(1).Shading.BackgroundPatternColor = 5232127
Case "Low": .Range.Cells(1).Shading.BackgroundPatternColor = 5880731
Case Else: .Range.Cells(1).Shading.BackgroundPatternColorInde x = wdNoHighlight
End Select
Reply With Quote