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?

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?

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?

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?

There are 19 different values. I used the 19 values (reps) on sheet 1 and
used color yellow as the highlight. If there was a way to select all 19 from
the drop down in auto filter I wouldn't have the need to color them yellow. I
am using excel 03' if that makes a difference.

"Gord Dibben" wrote:

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?

Since your yellow color is produced by CF you can't use the normal VBA
interior.colorindex property to find the color.

See Chip Pearson's site for finding CF colors.


Gord

On Thu, 6 Dec 2007 14:16:01 -0800, relo rob
wrote:

There are 19 different values. I used the 19 values (reps) on sheet 1 and
used color yellow as the highlight. If there was a way to select all 19 from
the drop down in auto filter I wouldn't have the need to color them yellow. I
am using excel 03' if that makes a difference.

"Gord Dibben" wrote:

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?

You could use a helper column. If the 19 values you want deleted are listed
on Sheet2 (in A1:A19), then enter
=Isnumber(Match(Cell, Sheet2!A$1:A$19, 0))
in an empty column next to your table and copy the formula down (replace
Cell with your actual cell reference). Then autofilter on this new column
for TRUE values and delete the filtered rows. Then turn off autofilter and
delete the helper column.


"relo rob" wrote:

There are 19 different values. I used the 19 values (reps) on sheet 1 and
used color yellow as the highlight. If there was a way to select all 19 from
the drop down in auto filter I wouldn't have the need to color them yellow. I
am using excel 03' if that makes a difference.

"Gord Dibben" wrote:

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?