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...
Easiest way is to use the REPT formula with the pipe "|" separator.
=REPT("|",K15*100)
Where you percent is in cell K15
If it is a number and not a percent then the *100 is not required.
Then format the cell with Font = Stencil or Playbill and use the Font Colour to change the "bar" colours
Should look like this.