You cannot use the conditional formatting option in excel to do this for you. But you can have a macro setup that will delete the rows.
I have a question - is fresh data updated in rows? or columns? Is one column set for one date?