Hello,
I currently have a table of variances shown by data bars. Green for positive, red for negative, applied by the stock Excel data bars feature in conditional formatting.
These work great, however sometimes when the variance is 0 for all cells, some random cells will have a green or red data bar of different length. I'm baffled...the table's cells use formulas, but I copy/paste values in other cells and to the Nth decimal place, the variance is 0.00000! Even evaluating the formula in Excel manually shows me 0.00. Why are these data bars being generated when the value is 0? Can't figure this out unless its a bug!
Thanks for any help.
I currently have a table of variances shown by data bars. Green for positive, red for negative, applied by the stock Excel data bars feature in conditional formatting.
These work great, however sometimes when the variance is 0 for all cells, some random cells will have a green or red data bar of different length. I'm baffled...the table's cells use formulas, but I copy/paste values in other cells and to the Nth decimal place, the variance is 0.00000! Even evaluating the formula in Excel manually shows me 0.00. Why are these data bars being generated when the value is 0? Can't figure this out unless its a bug!
Thanks for any help.