Suppose from the cell range C10 to C30 I have to answer in yes and no. For that I want that whenever I shift to various cells mentioned in the cell range. A drop down list is formed showing the choice to be entered in yes or no.