Complex Conditional Formatting

[Jeff]

Hi all-

I really need help with this one. I'm relatively new to
conditional formatting but I have a pretty complex one
that I need help on.

I have a workbook with two worksheets in it. On sheet1,
I have some data along with pie charts that are created
with data from sheet2. What I need to do is have the pie
chart area change color based on the data results in
sheet2.

Is this possible?

Jeff Gross

 

[MattShoreson]

Yes - but best not to do it with conditional formatting.

Use code to change the colours.

Use the worksheet_change event, or assign a macro to a button.
to trigger the code.

Then evaluate the data and change the colour of the pie segment
accordingly