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