How can we auto colour columns according to their value? For example, the
value is >3.5, then the col turns green, if <2.5 it turns red. Similar to
cell changes and conditional formatting, I suppose.
Bernard Liengme - 08 Sep 2006 14:30 GMT
See what Jon has to say
http://peltiertech.com/Excel/Charts/ConditionalChart1.html
http://peltiertech.com/Excel/Charts/ConditionalChart2.html
best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> How can we auto colour columns according to their value? For example, the
> value is >3.5, then the col turns green, if <2.5 it turns red. Similar to
> cell changes and conditional formatting, I suppose.