Hi!

In the data validation, allow list source box, you can
enter a formula to test for YES or NO:

=IF(E1="YES",F1:F10,G1:G10)

How it works:

If cell E1=YES use the values in F1:F10 as the source for
the dropdown, otherwise, use G1:G10 as the source.

Biff

-----Original Message-----
hi,

I have a drop down box in a cell. Based on a value of
anohter cell I have to fill my drop down box. what i mean
is, say if
GreeNPackage is "No" then I want the drop down box to
fill
a range of values. But if the GreeNPackage is "Yes" then
I
want the drop down box to fill another set of values. how
can i do this?

plenty of thanks

.