I want to keep the following rows there if anything below is in one the the columns listed: A,B,C,D, E, H & I: any #'s between 1-300 F: any "C's" or "I's" If it has a zero or blank in all columns A-I it can be deleted. Hope that makes more sense.

re: If it has a zero or blank in all columns A-I it can be deleted Does the code have to check for numbers like 500 in the specified columns or other letters in F? If the values will only be 0 to 300 or C or I then all we are really checking for is blanks or zeros. However, if a cell might contain 536 or Q, then we have to be very specific about what we search for before deleting a row. Let us know.

I was able to figure out the code I needed for this, however I'm trying now to find out the following: I've creating a drop down that has different words, once I select from the drop down my cell is white (before selecting I've saved it as red). Any way to make drop downs a colour?

You should probably post that question in a new thread under an appropriate subject line. P.S. When you do, please include more detail because I wasn't able recreate the problem with a simple Data Validation Dropdown list.