|
|
#7
10-05-2014, 10:54 AM
|
|||
|
|||
Code:
Sub DDOnExit()
ActiveDocument.Unprotect
Select Case ActiveDocument.FormFields("Dropdown1").Result
Case "Positive": Selection.Tables(1).Columns(Selection.Cells(1).ColumnIndex).Shading.BackgroundPatternColorIndex = wdBrightGreen
Case "Negative": Selection.Tables(1).Columns(Selection.Cells(1).ColumnIndex).Shading.BackgroundPatternColorIndex = wdDarkRed
End Select
ActiveDocument.Protect wdAllowOnlyFormFields, True
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Conditionally Color Formatting Text selected from a dropdown list in Word 2010
|
pgammag | Word | 9 | 08-20-2019 04:17 PM |
|
Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
|
Loosing Formatting on Data in dropdown box
|
arshaw | Word | 5 | 02-26-2013 12:37 PM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
| Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |
Windows 7 32bit 
Office 2010 (Version 14.0)
Threaded Mode