In which group would you like your answer?

--
Don Guillett
SalesAid Software

"Joe" wrote in message
...
I am using Excel 2002.

I would like to have a Validation list appear in a the cells in column 3
if the cells in column 1 have "CAE" as a part of their text; otherwise I
would like to have the cells in column 3 behave as if they have no
validation list (i.e. no dropdown arrow appears when any of the cells are
selected).

Is this possible; does anyonne know how to do it?

TIA,

Joe