Forum Discussion
Data bars
I wish to add a coloured data bar to represent the value in the cell. However the value in the cell is a percentage range (e.g 25-50%). Therefore I would like to file the cell with a colour between 1...
You could use the built-in conditional formatting for data bars with the understanding the feature looks at the column or a matrix as a whole to determine if 'half-filled' is the display for 50%, for example.
For example:
In Val A, 50% is the highest percentage in the column so it's a full bar. In Val B, we have 100%, so the data bars adjust according, 25%, 50%, and 75% look as you might expect. The matrix is an example of applying the rule to multidimensional data range.