View Single Post
 
Old 09-18-2012, 05:31 PM
pmregan pmregan is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Aug 2011
Posts: 1
pmregan is on a distinguished road
Question 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.
Reply With Quote