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