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.

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.



Roundy wrote:

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