Conditional format for form drop-down list?
I wasn't sure if this question should go into "UserForms" or "VBA". Please help me repost if I goofed...
I would like to add a drop-down list called "Results" to a form. The list would have three options: "PASS," "FAIL," or "NA/Not Tested." I would like to format the text of the selected option so that "PASS" appears in green, "FAIL" appears in red, and "NA/Not Tested" remains unchanged.
Can anyone help me accomplish this? I can create the drop-down, and populate the list, but I can't figure out how to wrap any code around it.
|