I have a cell that I would like the user to be able to enter text into only
if another cell contains the word "MDF". I would like to do this with
validation.

Here is what I have tried:

=IF(COUNTIF(C5,"*MDF*")0,0,€œ €œ)

I would like the formula to do nothing if the word "MDF" is in C5, if not I
want it to clear the cell thus the blank space.

Any suggestions?

Thanks,

Kevin

=IF(C5="*MDF*","",[your criteria])

Dave
--
Brevity is the soul of wit.


"kmwhitt" wrote:

I have a cell that I would like the user to be able to enter text into only
if another cell contains the word "MDF". I would like to do this with
validation.

Here is what I have tried:

=IF(COUNTIF(C5,"*MDF*")0,0,€œ €œ)

I would like the formula to do nothing if the word "MDF" is in C5, if not I
want it to clear the cell thus the blank space.

Any suggestions?

Thanks,

Kevin

Thanks, Dave! My criteria is the second part. How can I get warning message
to pop up explaining to the user that the entry is invalid? Can this all be
done from within validation?

Thanks,

Kevin

"Dave F" wrote:

=IF(C5="*MDF*","",[your criteria])

Dave
--
Brevity is the soul of wit.


"kmwhitt" wrote:

I have a cell that I would like the user to be able to enter text into only
if another cell contains the word "MDF". I would like to do this with
validation.

Here is what I have tried:

=IF(COUNTIF(C5,"*MDF*")0,0,€œ €œ)

I would like the formula to do nothing if the word "MDF" is in C5, if not I
want it to clear the cell thus the blank space.

Any suggestions?

Thanks,

Kevin