Hello,

I have this project which I'm working on where I would like to conditionally format the 2nd series of a column chart based on the first series' values.
For example if 2nd series is lower than 1st series, it should be colored in red. If it's greater than the first series, it should be colored in green, all this automatically based on data displayed on the chart. I could also use some VBA tricks, no problem with that.
Here's the current chart:
3642829038.png
So here I would like to color the "Real" series based on "Budget" series values which will have a fixed color.

I'd appreciate it if anyone could give me some pointers. Thanks!