Quote:
Originally Posted by headlockpdp
One last question, instead of a drop down menu, can I use a check box for conditional formatting? If checked, highlight row green. If not, no highlights.
|
Yes, you can do that, in which case it's simply a matter of testing the content control's checked state. For example, replace:
Code:
Select Case .Range.Text
Case "COMPLETE": Clr = wdGreen
Case "Pending": Clr = wdYellow
Case Else: Clr = wdNoHighlight
End Select
with:
Code:
Select Case .Checked
Case True: Clr = wdGreen
Case Else: Clr = wdNoHighlight
End Select