|What do you mean by "have some cells...highlighted"? |
What do you mean by highlighted? Selected? Change color? Something else?
What do you mean by "choose one from my drop down"?
You need to supply some more detail as to what you are trying to do.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.