Conditional clearing of cells

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.

I don't see how you could put a formula in the RED/GREEN/BLUE cells if you're setting their values from a validated list.

If you can't put a formula in those cells then it's impossible to put a formula in another cell to change their values.

So, which are you less keen on; using macros or leaving out the "Clear all selections" functionality.