I think Luke meant for you to filter for the value you used in CF to color the
cells.

i.e. Less than 123 or equal to "relo rob"


Gord Dibben MS Excel MVP

On Thu, 6 Dec 2007 12:36:01 -0800, relo rob
wrote:

Thanks for the advice and sorry for being a newby but I did see any way I
could do a custom filter for color.

"Luke M" wrote:

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?