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 - -

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 - -

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 - -