Print cells that meet conditional formatting criteria

[Guest]

Can you take a sheet that you have applied conditional formatting too, and
either create another sheet, or just print the cells that are red for example.

 

[Dave Peterson]

Is it possible, yes. Is it easy, no.

Chip Pearson has some nice code at:
http://www.cpearson.com/excel/CFColors.htm

Put your thinking cap on!

I think it's usually much easier to duplicate the conditional formatting
formulas in helper cells. Then inspect those helper cells for anything you
want.