Quote:
Originally Posted by ejungk99
Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection.
|
The macro only colours the cell containing the content control - because that's all it was written to do - and is only activated once the content control is exited.
Quote:
|
Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?
|
That suggests you have two or more macros with the same name, in which case you're using more than just the conditional format document as provided.