I have searched high and low (probably not hard enought tho!) for some code which will change the colour of bar charts conditionally - i.e. If the bar is above 90% it is red, if the bar is between 70 and 80% it is green etc.
I have 50 charts which already exist and I have seen ways of performing conditional charting which does n0t involve coding - but not appropriate for this. This situation i believe will require some code because the charts are dynamic themselves...
Has anyone got an example of some code where a bar chart is conditionally formatted?
Thanks for any help in advance!