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