How?? >> If Currency amount is less than $500,000 in column I, delete the whole row

Hello all,

I would like a formula to do the following...

If Currency amount is less than $500,000 in column I, delete the whole row.

Yes, there is a header row with text in it, which I want to remain. I'm using Excel 2003.


P.S. I hope I did the code tags right. I don't think that this is really code persay, but want to make sure I'm complying if it is. If this doesn't qualify as "code", please let me know and I won't code tag things like this in the future.

Thanks much