Data Validation w/ exceptions msg box
 

Hey,

I created a form utilizing the data validation and the Indirect function. I
have a list of products in Column A, depending on the product selected,
certain options are available in Column B. I want to create a warning
message if one of the options in Column B needs other information. Is this
possible?

Thanks,

Data Validation w/ exceptions msg box
 

of course.but you will have to give us more info.You may be able to use
helper cells and an =IF(OR(B2=1,B3=1,B4=1),"Danger Will Robinson
Danger",""),formatted in
large red letters,you could use a data validation formula,you could use a
macro.....--
paul
remove nospam for email addy!



"TC" wrote:

Hey,

I created a form utilizing the data validation and the Indirect function. I
have a list of products in Column A, depending on the product selected,
certain options are available in Column B. I want to create a warning
message if one of the options in Column B needs other information. Is this
possible?

Thanks,