What Rajesh asked for can only be done with programming: the clearing of
the dependent list input cells. Regular Excel functions cannot alter
the actual contents of cells or perform other manipulations of the
structure of the workbook (hiding/unhiding, deleting, etc). Of course,
you could just clear the corresponding dependent cell manually. You
could even use conditional formatting to flag that a displayed
dependent value does not relate to the independent value. But that
approach only serves to prompt the user to do the actual changing of
the cell contents.

I hope that answers your question.

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=382451