Hi all!

My manager created a survey and it has a series of drop-down forms (more than 30) to be exact. The survey is divided into categories. For example, the first category is about one's self and the choices on the drop-down box are NR, Yes and No. The second category will be about work background and the options will now include NA, Unknown, Yes and No.



For every category, the number of questions and options on the drop-down vary.

Is it possible to apply conditional formatting--specifically the colors of the cell and font whenever a choice is selected? NR is Red, Yes is Green and No is Yellow.

I've learned about the Legacy drop-down just now so I can't really follow the existing threads and I don't have any idea how to set up a password that I am seeing on the codes.

Any help is much appreciated. Thank you.

Please don't post about the same question in multiple threads. See replies in your other thread.

Thread closed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]