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
Bookmarks