Selecting cells that have been conditionally formatted

C

cwilkin1

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
 
P

paul

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
 
C

cwilkin1

paul said:
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
Click to expand...
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
 
P

paul

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.
 
G

Gord Dibben

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

F5>Special>Conditional Formats>OK

Edit>Delete


Gord Dibben MS Excel MVP
 
C

cwilkin1

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

F5>Special>Conditional Formats>OK

Edit>Delete


Gord Dibben MS Excel MVP
Click to expand...
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.
 
H

hot dogs

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.
 
Top