Selecting cells that have been conditionally formatted
 

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

i am not sure if you just want to delete the cells that are already yellow or
to find the cond formatted cells.To find the cond format cells
edit/goto/special/cond formats
--
paul

remove nospam for email addy!



" wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

paul wrote:
i am not sure if you just want to delete the cells that are already yellow or
to find the cond formatted cells.To find the cond format cells
edit/goto/special/cond formats
--
paul

remove nospam for email addy!



" wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I hope this is the right place to reply. I tried to put the cursor near
message but it would n ot go there. What I have is a list in Col A and
another list in Col B. I have ColB condition to color yellow any cell
which contents is in column A. I then delete these. As of now I select
each one manually and then delete. I hoping there is a way to select
them (or filter them) base on the criteria than the cell is formated in
the pattern yellow. Hopes this makes it clearer.

Chuck

Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

if you have a criteria make another column to diplay that criteria somehow
then sort by that column so all the yellow cells are together so you can
delete them all at once.Then sort it back to how it was.
--
paul

remove nospam for email addy!



" wrote:

paul wrote:
i am not sure if you just want to delete the cells that are already yellow or
to find the cond formatted cells.To find the cond format cells
edit/goto/special/cond formats
--
paul

remove nospam for email addy!



" wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I hope this is the right place to reply. I tried to put the cursor near
message but it would n ot go there. What I have is a list in Col A and
another list in Col B. I have ColB condition to color yellow any cell
which contents is in column A. I then delete these. As of now I select
each one manually and then delete. I hoping there is a way to select
them (or filter them) base on the criteria than the cell is formated in
the pattern yellow. Hopes this makes it clearer.

Chuck

Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

Is that 2000 out of the 700 cells or 2000 maybe should be 200?

F5SpecialConditional FormatsOK

EditDelete


Gord Dibben MS Excel MVP


On 13 Oct 2006 13:14:48 -0700, wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

Gord Dibben wrote:
Is that 2000 out of the 700 cells or 2000 maybe should be 200?

F5SpecialConditional FormatsOK

EditDelete


Gord Dibben MS Excel MVP


On 13 Oct 2006 13:14:48 -0700, wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I made a mistake it should read 200 not 2000, sorry. I tried your
suggestion but it deleted the whole list because every cell in that
column is "conditional formatted" only the ones that meet the criteria
have a background in yellow. I just do not know how to express the
criteria as "the cell must have a background of yellow, i know it is
pattern 6.
Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

See Chip Pearson's site for much more on CF.

You will find that the cellcolorindex will not work with conditionally formatted
cells and more code is required.

http://www.cpearson.com/excel/CFColors.htm


Gord


On 13 Oct 2006 16:34:02 -0700, wrote:


Gord Dibben wrote:
Is that 2000 out of the 700 cells or 2000 maybe should be 200?

F5SpecialConditional FormatsOK

EditDelete


Gord Dibben MS Excel MVP


On 13 Oct 2006 13:14:48 -0700, wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I made a mistake it should read 200 not 2000, sorry. I tried your
suggestion but it deleted the whole list because every cell in that
column is "conditional formatted" only the ones that meet the criteria
have a background in yellow. I just do not know how to express the
criteria as "the cell must have a background of yellow, i know it is
pattern 6.
Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

Gord Dibben wrote:
See Chip Pearson's site for much more on CF.

You will find that the cellcolorindex will not work with conditionally formatted
cells and more code is required.

http://www.cpearson.com/excel/CFColors.htm


Gord


On 13 Oct 2006 16:34:02 -0700, wrote:


Gord Dibben wrote:
Is that 2000 out of the 700 cells or 2000 maybe should be 200?

F5SpecialConditional FormatsOK


Thanks, I'll see if I can understand it

EditDelete


Gord Dibben MS Excel MVP


On 13 Oct 2006 13:14:48 -0700, wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I made a mistake it should read 200 not 2000, sorry. I tried your
suggestion but it deleted the whole list because every cell in that
column is "conditional formatted" only the ones that meet the criteria
have a background in yellow. I just do not know how to express the
criteria as "the cell must have a background of yellow, i know it is
pattern 6.
Thanks,

Chuck

Selecting cells that have been conditionally formatted
 

Use the same formula you have for the conditional formating to give a '1' in
column C, then search for 1's in column C and delete.

" wrote:

paul wrote:
i am not sure if you just want to delete the cells that are already yellow or
to find the cond formatted cells.To find the cond format cells
edit/goto/special/cond formats
--
paul

remove nospam for email addy!



" wrote:

HI,I have a list in column D of about 700 items (cells) and and a
number of them (maybe 2000 have the background color of yellow (this
was done with conditional formatting) I WANT AN EASY WAY TO SELECT THE
CELLS WITH THE YELLOW BACKGROUNd AND THEN DELTE THEM. I know the basics
but not much more about Excel.

I hope this is the right place to reply. I tried to put the cursor near
message but it would n ot go there. What I have is a list in Col A and
another list in Col B. I have ColB condition to color yellow any cell
which contents is in column A. I then delete these. As of now I select
each one manually and then delete. I hoping there is a way to select
them (or filter them) base on the criteria than the cell is formated in
the pattern yellow. Hopes this makes it clearer.

Chuck

Thanks,

Chuck