View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Dependent Data Validation with Illegal Characters

How are the item lists in your workbook set up?

wrote:
On Jan 12, 11:37 pm, Debra Dalgleish
wrote:



Debra,

Can you please explain to me how I can make the Illegal character
formula work for a 3rd category? I want to have the 3rd category
options dependent upon the combination of what is selected for both
categories 1 & 2. Please keep in mind that both categories 1 & 2
contain multiple words with illegal characters.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html