Hi,

I have a worksheet that needs to be colour coded according to the value within. So far, there are 11 colours that must be used and I am colour coding it manually.

I tried using conditional formatting to try and get it done automatically but realised it will not work since it can only be set up to a max. of 3 conditions.

How do I go about formatting of the cells to do the above automatically?

Thanks in advance!