|
|
|
|
#1
08-09-2017, 12:51 PM
|
|||
|
|||
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 
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help with Hide/Display of sections of document based on Drop Down selections
|
turnquistcm | Word | 2 | 05-03-2017 07:05 PM |
|
Best way to load data into a template based on user selections
|
Timbo | Word | 1 | 11-07-2013 05:14 AM |
|
Contact details entered based on multiple drop down selections
|
ntropey87 | Word VBA | 4 | 04-20-2013 11:19 AM |
| add values to dropdown selections and calculate | guyhs | Word | 7 | 10-24-2012 05:11 PM |
| Template: group dropdown selections | mfoe33 | Word | 0 | 10-15-2012 02:58 AM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode