I now see where F8 comes into play and how this can be useful.

I believe I have found where my current issuse begins.

With the following code:

[vba]Case "voteauth"
If CC.Range.Text = "Jerry Lewis" Then
oVoteAuth = True
End If
End Select[/vba]

if I set a breakpoint at the End Select line and then get the macro to run OnExit, even if I have selected "Jerry Lewis" in the voteauth drop down, when I hover over the oVoteAuth variable i see oVoteAuth = False. I need this to be True for my conditional formatting to show properly. In this case "Jerry Lewis" is the exception. If "Jerry Lewis" then don't follow the rules that all other content controls follow, follow a new set of rules.

I figured this is where the code was going wrong but I believe this verifies it.

Frosty,

Can you confirm that I am on the right track.

If so I am at a loss.