Is there a way to color code the marking in a checkbox so that if someone marks certain checkboxes, they will stand out in color? For example, I have checkboxes for "Yes", "No", and "NA".
Since checkboxes can only have a checked/unchecked state, I assume you're using different checkboxes for your "Yes", "No", and "NA" responses. Unless you use a macro to make these choices mutually exclusive, you could end up with any combination being checked/unchecked
(i.e. none checked, one checked, any two checked or all three checked). A simple dropdown with "Yes", "No", and "NA" choices, however, could achieve the same result without a macro.
As for the conditional formatting, that depends on the kind of checkbox you're using - formfield, ActiveX or content control. The code for each kind of checkbox is quite different from the code for the others. Additionally, if you're using multiple checkboxes,
there would have to be a means for the code to tell them apart (e.g. each one is in a different column in a table)
If you decide to use dropdown content controls, the code for however many of them you have in your document could be as simple as:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)
Application.ScreenUpdating = False
With CCtrl
If .Type <> wdContentControlDropdownList Then Exit Sub
With .Range
Select Case .Text
Case "No": .Shading.ForegroundPatternColor = wdColorPink
Case Else: .Shading.ForegroundPatternColor = wdColorAutomatic
End Select
End With
End With
Application.ScreenUpdating = True
End Sub