ID and/or filter rows with 'Fill Color'

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

Perfect. Thanks for the help.

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)