software

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,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),quot;Danger Will Robinson
Dangerquot;,quot;quot;),formatted in
large red letters,you could use a data validation formula,you could use a
macro.....--
paul
remove nospam for email addy!
quot;TCquot; wrote:

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