Conditional Formatting relating colours to numbers

Hello.

I have built an input channel list for use in the audio industry. you will see in the second column (Stagebox/Patch) a numbers and a colour. the numbers are not decimal but instead duodecimal.

I have three stage boxes with 12 inputs each and these are represented as
1.1 - 1.12
2.1 - 2.12
3.1 - 3.12
Furthermore the stage boxes are colour coded and this is represented on the sheet also with
Stagebox 1 - Green
Stagebox 2 - Red
Stagebox 3 - Blue

I have completed the sheet as I would like it but I would like the colour filling to be automatic on selection of the number.

There is data validation used on this sheet which limits selections. These can be found hidden on sheet 3.


Kind Regards
Alex Abbey


PS if it's not too much trouble, an explanation of how it was done would be greatly appreciated.