print only color filled rows

[chief]

what code in a command button could make it so that only rows that ar
not color filled will be printed?

thank

 

[Don Guillett]

You could HIDE the color filled rows.

 

[Dave Peterson]

I'd use a UserDefinedFunction to return the value of the color in a help column
of cells.

Chip Pearson has a couple of functions at:
http://www.cpearson.com/excel/colors.htm

Then I'd just apply Data|Filter|autofilter to show only the rows I wanted to
print.
(custom, equal to, ...)

Then print, and data|filter|showall.

And if that helper column is too ugly, hide it before you print.