Is it possible to conditional format a bar

[mk000]

Ok, say i have a column chart. Imagine the data is as below...

place1 10
place2 8
place3 10

Saw I format the chart columns to be a color, blue. Can you conditional format to make any column thats <10 green?

I don't know if this is possible.

Thanks!
mk

 

[Damon Ostrander]

Hi mk,

Yes, this is possible with a bit of VBA code. But it would be easier to send you an example than to describe in detail here. If you would like to send me an email requesting my conditional barcolor example, or a PM with your email address, I will reply with the example attached.

Damon

 

[mk000]

Thanks, Damon I got it.

I had to set up a class module, I found a good example on the FAQs here...

Works like a charm for anyone looking to conditionally format a bar chart.

http://www.mrexcel.com/archive/Chart/6809.html

 

[Greg Truby]

http://www.peltiertech.com/Excel/Charts/ConditionalChart1.html

Takes a smidgeon of setting up, but no VBA needed.