Microsoft Office Forums - View Single Post - Setting a particular table cell background color when an option button is selected in Word 2007

gmaxey · 03-13-2015, 06:51 AM

Code:

Select Case fcnCellText oRow.Cells(lngIndex)
  Case "Y", "Y*"
      oRow.Cells(lngIndex).Range.Select
      oRow.Cells(lngIndex).Range.Shading.BackgroundPatternColor = wdColorRed
 Case Else 'Do nonthing
 
 End Select

You could use a Content Control dropdown "Yes/No"