Hello
I have found a VBA script on the WEB that colors a chart based on the "fill" color of the data. Sorry, I don't remember the original author of the VBA so I can't contact him directly.
The script works like a charm... only ... it does not work when you have conditional formatting.
Attached, I have a spreadsheet which highlights the problem.
There are two colored tables and two graphs based on each of the tables. The tables look the same but the second table contains conditional formatting based on the value of C19 through C22.
I have created a button that executes the macro. The top graph works like a charm but the graph based on the conditional formatted table does not have the right colors. In fact, they are all "NO fill" colors which are invisible.
Is there a way to modify the VBA macro so that the colors are updated in the graph based on conditional formatted tables ?
Thanks
Canadane
Bookmarks