I have been using conditional format to colour cells depending on value,
however, I want to use more than 3 colours,

can anyone think of a good solution?
Many you for your help