Conditional format for form drop-down list?

pmregan · #1 09-18-2012, 05:31 PM

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.

macropod · #2 09-19-2012, 07:09 PM

To do this the formfield needs an 'on exit' macro. See attached.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Drop down list, Can it be done???	garethreid	Outlook	0	08-09-2012 06:08 AM
Drop Down Form Help	jwm1346	Word	3	07-31-2012 07:49 PM
Drop Down List using SYMBOLS	sm5948	Word	2	09-28-2011 05:05 AM
Conditional data validation (list drop-down)	click4akshay	Excel	2	04-28-2011 01:51 PM
25 item max in drop down form	sonicvalley	Word	0	07-26-2010 11:12 PM