Can you please tell me if it is possible to use condtional formating in calc (LibreOffice Portable win 10) to change the amount of fill colour in a cell according to the percentage entered in it?
Cell % value or number = 1 % - the cell is fillled with 1% colour (any chosen single colour)
Cell % value or number = 50 % - the cell is fillled with 50% colour (any chosen single colour) and so forth till 100% coloured if the cell value = 100% / 100.
I have the cell changing colours according to conditions - cell value in between 1 to 50 = red, 51 to 70 = yellow, 71 to 99 = green and 100 = blue but it would be ideal and a lot more visually pleasing if the colour fill changed depending on the value in the cell.
Thanks in advance for any assistance.