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