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