Hi Guys

I have a spread sheet, containing around 3000 rows which i have conditional formatted so that cells are highlighted that contain certain values, i.e values over a certain amount
(red for above $50, orange for $20-49.99 and yellow for $10-19.99 etc)

Is there anyway that i can then quickly remove any rows which do not contain any prices that fall into the above categories, or export the rows into a seperate sheet that DO contain the required values?

Sorry if this sounds backwards - bit of an Excel noob!