Write a simple formula or macro in Excel.

Script for removing phrases with a negative words. There is a file with text cells. In a particular column will be entered the words. Need to make text cells containing these words is deleted.