View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Conan Kelly Conan Kelly is offline
external usenet poster
 
Posts: 419
Default Drop Down Menu Conditional Formatting

karen,

When you say "drop down menu", do you mean Data Validation?

If so, this page gives instructions on how to acomplish what I think you are
describing:

http://www.contextures.com/xlDataVal02.html

HTH,

Conan




"Karen Smith" wrote in message
...
I've created a drop down menu for cell I4 that allows users to choose A,
B, C
or D. Depending on what letter they choose, I want another drop down
menu.
Such as, if they choose A, I want their choices to be Apples, Oranges,
Grapes. If they choose B, I want their choices to be Grapefruit, Kiwi,
Plums. And so on. How do I do that?