Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ID and/or filter rows with 'Fill Color'
Situation:
Spreadsheet with 500+ rows of data Several rows have been highlighted to identify as action items Criteria used to ID and highlight are not included in the report data Report is generated daily by person or person's unknown. Is there a way to filter based on Fill Color? (ie .ColorIndex=36) Or is there a way to insert a filter key (ie 'X') in an adjacent column of rows which are highlighted. Thanks in advance! - - TB - - |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ID and/or filter rows with 'Fill Color'
See http://www.rondebruin.nl/easyfilter.htm, it has a colour filter option.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TOMB" wrote in message ... Situation: Spreadsheet with 500+ rows of data Several rows have been highlighted to identify as action items Criteria used to ID and highlight are not included in the report data Report is generated daily by person or person's unknown. Is there a way to filter based on Fill Color? (ie .ColorIndex=36) Or is there a way to insert a filter key (ie 'X') in an adjacent column of rows which are highlighted. Thanks in advance! - - TB - - |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ID and/or filter rows with 'Fill Color'
Perfect. Thanks for the help.
"Bob Phillips" wrote: See http://www.rondebruin.nl/easyfilter.htm, it has a colour filter option. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "TOMB" wrote in message ... Situation: Spreadsheet with 500+ rows of data Several rows have been highlighted to identify as action items Criteria used to ID and highlight are not included in the report data Report is generated daily by person or person's unknown. Is there a way to filter based on Fill Color? (ie .ColorIndex=36) Or is there a way to insert a filter key (ie 'X') in an adjacent column of rows which are highlighted. Thanks in advance! - - TB - - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill Color is added to additional rows | Excel Discussion (Misc queries) | |||
How can I filter on rows that are shaded in a different color? | Excel Worksheet Functions | |||
excel should allow me to filter rows on basis of the cell color | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Select or Filter by Fill Color | Excel Worksheet Functions |