Hi

I would like to track training progress that is visual.

I want 4 cells that make up a 'cube' to be coloured according to what number is selected from a drop down list in the top left cell of the cube.

The first cell A1(top left) has a drop list of numbers 0 - 4. When 1 is selected the first cell (A1) is coloured yellow. If 2 is selected, (A1 & A2) are coloured Orange. If 3 is selected, (A1, A2, B2) are coloured Blue and finally if 4 is selected all cells in quadrant are coloured (A1, A2, B1, B2) Green. If 0 is selected, all 4 cells return to a blank state.

I used data validation for the list of 0 - 4. This is in cell A1

I do not want the number selected to be visible once it's chosen. I want that to just drive what segments of the quadrant will be coloured.



Any help would be appreciated.

Attached Files

Colour Quadrants.xlsx (8.6 KB, 14 views)