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

  • Thread starter Thread starter Tim Harding
  • Start date Start date
T

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)
 
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
 
Back
Top