Conditional Formatting on Word (Dropdown List)

macropod · #1 12-05-2014, 05:19 PM

In that case, you could add a 'ContentControlOnExit' macro to your document's 'ThisDocument' code module, coded along the lines of:

Code:

Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)
With CCtrl
  Select Case .Title
    Case "Dropdown1", "Dropdown2"
        Select Case .Range.Text
          Case .PlaceholderText, "If ""Yes"", Select", "n/a"
            .Range.Font.ColorIndex = wdRed
          Case Else
          .Range.Font.ColorIndex = wdAuto
        End Select
  End Select
End With
End Sub

where "Dropdown1", "Dropdown2", etc. are the titles you assign to your content controls and .PlaceholderText, "If ""Yes"", Select", "n/a", etc. are the default text and any other options you want to assign the red colour to.

daviieejay · #2 12-05-2014, 06:09 PM

Hi Paul,

Two things for you:

1) When I add "Select Date" or another one of the headers, I get an error message. Not sure why.

2) All of the dropdown lists turn into red font, as opposed to just those options. Would you know why?

Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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
Dropdown conditional formatting	tlkc67	Word VBA	6	10-05-2014 10:54 AM
Conditional formatting that ignores other formatting rules	info_guy2	Excel	1	07-03-2014 10:07 AM
Dropdown List in Microsoft Word 2010	bfarquhar	Word	2	04-02-2014 07:48 PM
link conditional info in word based on excel list	stijnvanhoof	Mail Merge	1	11-13-2012 01:55 PM