Hi!

To do EXACTLY what you want will require VBA code. I can't help you with
that.

An alternative to code would be to use conditional formatting to set the
cell font color to be the same as the fill color if the value in the cell is
not part of the named range that is currently selected from the first drop
down.

That will achieve the effect you're after of "clearing" (or at least,
appearing to be clear) the cell but if you have other formulas that are
dependent upon this cell it may make things more complicated to deal with.

Biff

"Sagu" wrote in message
oups.com...
Hello folks,

Thanks for replying to my query.

The scenario is i have created drop downs using Ranges and Validation.

The first drop down contains a Named range
The second drop down is populated by using a IF condition within the
Validation Settings and hence depending upon the selection in the first
drop down list, the second drop down is populated.

The Issue here being, the cell containing the second drop down list
"retains" the value of the previous selection.

For example :

Drop down list in Cell A1 lists all the Categories.

Drop down list in Cell B2 lists all the products.

For the first time, the selection in the Cell A1 (Categories) populates
the data in the drop down list of the Cell B2 ( Products)

From the Second time, if the selection in the Cell A1 Changes, the drop
down list populating the Cell B2 changes, but NOT the content of cell
B2,which retains the value of the previous selection . I need to clear
the value present in the cell B2 ( which is a value from the previous
selection)

Hope i am clear in conveying my requirements.

Please let me know if there any issues, else i can send the excel file
across..

Thanks once again for spending your time on this..
Sagar