Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
delete row of same colors
I have an excel file of 100 names and address, etc. I have color coded some
of the row in red. I want to delete all of the colored rows. it is the entire row that is colored not the text. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
delete row of same colors
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. Hold SHIFT key and scroll down to bottom of dialog box and select last cell. EditDelete will get rid of the red rows. If earlier version you would have to use VBA See Chip Pearson's site for cellcolorindex function. http://www.cpearson.com/excel/colors.htm Gord Dibben MS Excel MVP On Thu, 20 Sep 2007 14:18:01 -0700, Tele0299 wrote: I have an excel file of 100 names and address, etc. I have color coded some of the row in red. I want to delete all of the colored rows. it is the entire row that is colored not the text. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
How to Delete a Range in Closed Workbook (to Replace Delete Query) | Excel Discussion (Misc queries) | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions |