M mkapashi New Member Oct 22, 2010 #1 Is it possible to conditionally format individual error bars i.e. if value of error bar 2 is less than error bar 1 then error bar 2 is red else green?
Is it possible to conditionally format individual error bars i.e. if value of error bar 2 is less than error bar 1 then error bar 2 is red else green?
Hui Excel Ninja Staff member Oct 23, 2010 #2 Mkapashi The only way I can see to do that is to have 2 data series with same values One series can have no fill color and so isn't visible Add + error bars to one series and - error bars to the other series You can then color them as you wish But without using some VBA code there is no way to do it based on values
Mkapashi The only way I can see to do that is to have 2 data series with same values One series can have no fill color and so isn't visible Add + error bars to one series and - error bars to the other series You can then color them as you wish But without using some VBA code there is no way to do it based on values