Data bars in Excel are a form of conditional formatting that makes it easy to visualise the values in a range of cells, by shading a portion of the cell proportional to the value in it. On their own they are pretty useful but have a few limitations, but by harnessing a little known ‘feature’ with a little bit of VBA code and some creative thinking they can be made much more useful.
