Conditional formatting using an index formula

[George77]

Hi,
I have used the formula below to apply conditional formatting to the cells in my worksheet. The conditional formatting is based on the result of inputting a value in the column heading and a value in the row headings. The problem I have is that all results are the same colour. I need the colour to be different based on each value in the row headings A9:A15

=INDEX(C9:CR15,MATCH(CV10,A9:A15,0),MATCH(CV12,C1:CT1,0))

 

[Fluff]

You will need a new rule for each colour.

 

[George77]

Thank you

 

[Fluff]

You're welcome