Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I conditionally delete rows based on cell contents? | Excel Worksheet Functions | |||
.FontSize conditionally | Excel Worksheet Functions | |||
Conditionally Formatting | Excel Worksheet Functions | |||
Background changes conditionally | Excel Discussion (Misc queries) | |||
Is there a way to conditionally hide a row? | Excel Discussion (Misc queries) |