View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Karen Smith Karen Smith is offline
external usenet poster
 
Posts: 45
Default Drop Down Menu Conditional Formatting

Yes, I mean Data Validation.....I'm actually trying to work with the
contextures.com site you sent me, but I'm having a little trouble. Would you
allow me to call you to get a few quick questions answered? you can email me
at

"Conan Kelly" wrote:

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?