Thanks. This is helpful and useful, but I really want to eliminate the cells. All of the cells in question are in the same column and there are several similar columns in the dB. I am hoping for a one step process to eliminate the data and tighten up the spreadsheet at the same time.
I am working with a big dB. I have multiple (1,435) columns of data and about 18,000 rows. I want to eliminate all of the cells with specific background colors. Can I do this? If so, can someone point me in the right direction.
I am John. When I am not posing for toothpaste ads or modeling the latest in men's underwear for Cosmo, I spend my time developing interplanetary transfer devices. I use Excel to ease the suffering of countless millions.
Or maybe I just use it for my small business.