Can this be done????......Help !..A Challenge

[Tim Harding]

What I am wanting to do is.......

I have a file with multiple worksheets...

One of the worksheets has conditional formatting....red
for above target..green for below target....

What I would then like to do is...from the data which is
either above or below target...plot these into a pie
chart....but keep the conditional formatting so that the
pie chart is full of red or green sections...

I can provide a copy of what i would like....if you can
help..id be much appreciated.

Tim Harding

(e-mail address removed)

 

[dave]

I think I can help. Send me a copy...

 

[Dave Peterson]

I think using cells on the worksheet (and mimicking the conditional formatting
in those cells) is a lot easier than writing code to examine the conditional
formatting rules.

You could always dedicate a column or two for this info. If you don't want to
see the columns, then hide them when you're almost done.

But if you're really curious about looking at conditional formatting, take a
look at Chip Pearson's web page:

http://www.cpearson.com/excel/CFColors.htm