In Excel 2007, I have cells with the following background colors:
red
blue
green
no fill
I have an AutoFilter on. I can filter by each color or by 'no fill.' Is there a way to filter for all cells with color (i.e. red, blue and green) so that only cells with a color background are showing...