Data Cleaning Excel VBA

Description of excel work: Hi,

I'm doing some stock market analysis (Fama French Factor Based). I have downloaded stock return data but my source data is quite messy (for example when a stock stops trading in this dataset the price data remains the last trading day for the rest of the sample and isn't just N/A). Therefore I'd like to clean the data up in a few different ways:

Delete firm data when they have zero total returns
Delete firm data when they have zero price returns
Delete any firm data with penny stocks
Delete any firms with prices over £1000
Flag any returns over 1000%

For the above I'm looking for deletion (well marking data as NA) for only that time period for the firm and would like any other data to be kept in the database

I Hope this makes sense - the excel file is, to my mind, well structured so hopefully there shouldn't be too much you need to do on that front and I would like the work done as soon as possible. I've attached a file with an example of the data and will obviously be happy to chat through the requirements in more detail before carrying out the work
Design and target audience: -
Extra notes: