Changing data bar colour using VBA

Hi guys,

Ive been struggling with this...

I have a table with a range of values (AE6:AE15) for which I want to show data bars inside the cells. I want the data bar configuration to be the shortest bar to correspond to the largest value and viceversa. However, this column has both negative and positive values, and it would be great if I could have the negative values in red and the positives in blue. This is what I have tried so far... Any ideas??

Please Login or Register  to view this content.

Thanks in advance!!