Hide or Delete Rows

HI,

I'm looking for a way to automatically hide or delete a row if column "E" shows "completed", 
G" shows "completed" and "I" shows "discarded".

Is there anyway to do that?

Thank you