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