Turn on the macro recorder and set up the validation you want.

Now go to the calculate event of the worksheet and incorporate that basic
code in a loop through the cells in column 3.

If calculate doesn't update it frequently enough, then you can use the
selection change event (not sure how CAE is produced in column 3, so you
would have to be the judge of what event is best to use).

--
Regards,
Tom Ogilvy

"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