Line delete automaticaly

Hi,

Is it possible to delete complete lines automaticaly?

I mean that for example, I want to delete all lines containing a certain word or phrase (not a single cell or a find replace), say all lines that contain the word ''blue'', can this be done or do I have to scroll down the entire worksheet and manually delete the lines?

Thanks!