Filter by Cell Color and Text?

[yoyoma123]

I am using Excel 2007. Is it possible to filter a column on both a format condition AND a content condition?

For example, I want to filter by Duplicate cells (Format Condition: Cell color=red), and cells that contain the text "ABC".

Currently, I am filtering by cell color, but when I apply the text filter, the color filter will be unselected. And vice-versa.

I know I can make an identical column and filter once in each, but I am just curious if there is a way to do it without having to.

Thanks!