I want to create a themal analysis problem whereby the results of the
calculation are displayed in a grid of cells (representing the shape of the
item). I then want to apply conditional formatting which colours the cells
depending on the value. I want there to be 10 colours ranges. I can do this
easily for four colours using standard conditional formatting but I want to
use 10 colours, is there a way to expand the conditional formatting?