Thread: Conditional Format drop-down box

Hi,

I have a drop down box in word 2010 with the options "YES", "NO" and "N/A". I want to have conditional formatting for different color & font depending which is chose. e.g:

Yes = green
No = bold & red
N/A = gray

is there a way to do this?

Thanks in advance.

Hi omarq,

You could do that via an 'on exit' macro attached to the formfield and coded as:

Sub ConditionalFormat()
With ActiveDocument.FormFields("Dropdown1")
    .Range.Font.Bold = False
  If .Result = "Yes" Then
    .Range.Font.ColorIndex = wdGreen
  ElseIf .Result = "No" Then
    .Range.Font.ColorIndex = wdRed
    .Range.Font.Bold = True
  ElseIf .Result = "N/A" Then
    .Range.Font.ColorIndex = wdGray50
  Else
    .Range.Font.ColorIndex = wdAuto
  End If
End With
End Sub

where 'Dropdown1' is the formfield's internal bookmark name.

Is this for a dropdown formfield, or something else? If not for a dropdown formfield, then what?

You can't apply different colors to your different combobox entries - they must all be the same color. Document content can be any color.