View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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