I'm using Excel 2010, and have a spreadsheet with columns containing Red, Blue, yellow, and green cells, plus some with no color. If I apply an autofilter, I can filter for any individual color, or for no colors. But how do I do it if I want all colored cells, or to filter out the non-colored?

Thanks in advance,
John