Conditionally delete
 

Hi,

Does someone have script that will allow me to delete all cells that
are blue (in a worksheet)? Or does it have to be cell specific?
Thanks.

James

Conditionally delete
 

Chip Pearson has some good info here on working with colors.........

http://www.cpearson.com/Excel/colors.htm

Vaya con Dios,
Chuck, CABGx3




"James" wrote:

Hi,

Does someone have script that will allow me to delete all cells that
are blue (in a worksheet)? Or does it have to be cell specific?
Thanks.

James

Conditionally delete
 

Are the cells colored blue manually or by Conditional Formatting?

If by CF, use the same criteria to select the cells.

By "delete" do you mean clear contents or deleteshift up or left?

If manually formatted to blue...................

If you have Excel 2003(don't know about 2007)

You could try this alternate method which doesn't use VBA or any add-ins.

In 2003 you can specify the Format color to look for under
EditFindOptionsFormatFormat.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted.

SHIFT + End + Down Arrow to select all found cells.

The selected cells can then be EditCleared or Shifted.

Otherwise you would need VBA


Gord Dibben MS Excel MVP

On Tue, 06 Nov 2007 08:35:21 -0800, James wrote:

Hi,

Does someone have script that will allow me to delete all cells that
are blue (in a worksheet)? Or does it have to be cell specific?
Thanks.

James