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