Hello,

I have created a form in Excel 2003 which has a set of drop-down boxes to allow users to select either RED/GREEN/BLUE for a variety of questions. I now want to add one last question at the bottom: "Clear all selections?" and give a drop-down box with only YES option in it.

Once the user has filled out the all form fields, she may choose to clear all her selections by simply selecting YES against "Clear all selections?"

Now, I believe I'll need to put some sort of formula in each of the RED/GREEN/BLUE drop-down type of boxes which will tell them to clear their selections the moment the user says "YES" to the last question, else retain whatever selection exists in those boxes.

Could someone suggest me a simple formula to achieve this, if at all this is possible to do? I'm not keen on using macros inthis form. Thanks.