you are right in thinking that i want an autodrop based on
data->validation. The example you have taken, exactly matches my
problem. But i cud not figure out a sol. I tried indirect(C1). Does
not work. I named the range of red colours as RED, but don't know
where and how to use it.
Can u please work out a solution and send it to me?