Hello, I hope somebody can help me.

I have a spreadsheet with the following information

1 - "Groups" numbered 1 to 10, the user then selects their required colour i.e. Person A might have Group 1 as Red but Person B might be Blue
2 - "Products" number 1 to 30 are assigned a Group from above list and given a name i.e. "CHIPS"

There is then a 5x6 grid numbered 1 to 30 which contains the correct Product text changed to upper case and the required colour from the Group list. i.e. if Products 1 to 6 are in Group 1 and Group 1 is Red then the relevent squares on the grid should be red.

I have done it all except the colour on the grid, how can this be done? I have attached the spreadsheet for reference.


SE-S3000.xlsx