I'd use an Autofilter, then do a custom filter to find those cells. Then just
select them all in one go, and delete them.
--
Best Regards,

Luke M


"relo rob" wrote:

I have used conditional formatting with a formula is statement to highlights
cells in a column of about 5800 rows. Now that certain cells are highlighted
with one color how can I delete just them cells so I can work with the data
that is left?